Skip to main content

Data Types

Holistics's Generic Data Types

Within each data source, the same data types can be implemented in different ways and called by different names. For example, remembering all the different names for integer numbers across all of your data sources requires serious mental efforts.

To ease up the user experience, we implemented a Generic Data Types system that is used across Holistics's UI. They are:

  • Number: Including both whole and decimal numbers
  • True/False: Map to boolean data types
  • Date
  • Datetime
  • Text

When interacting with your data via Holistics, you only need to know these data types, and Holistics will automatically map them to the most sensible option in your database.

Data Type Mappings in Data Imports

For more information about how data types are mapped during data imports, please visit Import Data.

Changing data types of fields in Holistics

You can create a custom dimension and use your SQL DB's equivalent of the CAST function to create a new field with the correct data type. e.g. CAST({{ #THIS.fielda }} as INTEGER) to change a field data type to a number in MySQL or Snowflake.

Let us know what you think about this document :)