Skip to main content
You are viewing the documentation for Interana version 2. For documentation on the most recent version of Interana, go to


Scuba Docs

How to change column types

Steve A.

Interana does its best to associate  the correct column type with each column. However, should you want to change a column type, Interana allows you to do so manually.

Changing a column type requires a re-ingest of the data to get the correct values.

We have the following conversion types:

Type Conversion Function
Number to_int, to_int_set, to_decimal, to_dollars
String to_string, to_string_set, to_lower
Date date_to_milli, to _milli, micro_to_milli, second_to_milli
User Agent to_parsed_user_agent, to_browser_id
IP Address ip_to_geo
URL to_parsed_url
To change the type of a column:
  1. Identify the column(s) that needs to be changed
  2. Use the following command./opt/interana/backend/import_server/change_column_type -t 'Table_name' -n 'Column' -f 'conversion_type'
  3. Re-ingest the data.
  • Was this article helpful?