Supported data types and formats

Sigma supports various data types and formats to facilitate effective analysis and reporting. Data types apply to retrieved¹ and direct input² data to determine how Sigma structures, interprets, and manipulates your data. Data formats enable you to display the data in a clear and meaningful way.

This document defines the supported data types and provides an overview of data type formats and constraints.

1 Retrieved data refers to data that Sigma sources from your connected cloud data warehouse (CDW) or database management system (DBMS). Sigma retrieves and transforms data to a type corresponding to the native CDW or DBMS data type. When native data type support doesn’t exist, Sigma transforms the data to text.

2 Direct input data refers to data uploaded through CSV or manually entered into input tables.

Sigma data types

Sigma supports the following data types:

You can identify column data types in workbooks by referencing the icons in the Element properties > Columns list or the Column details modal.

Text

The text data type supports unstructured strings of characters (letters, numbers, symbols, and spaces) that represent textual information.

When Sigma retrieves data represented by a CDW or DBMS data type that isn’t supported, the data is transformed to text by default.

For a list of functions provided to operate on text data, see Text functions overview.

Number

The number data type supports structured numeric digits that represent numeric values or quantitative information.

All data represented as integers, fixed-point decimals, or floating-point numbers in your connected CDW or DBMS map to Sigma's number data type. Integers cast to int64 and can present up to 19 digits of precision, while fixed-point decimals and floating-point numbers cast to float64 and present 15-17 significant digits. Sigma also supports direct input values using input tables with up to 19 digits both before and after the decimal point.

💡

If you need to display precise number values that exceed the maximum number of digits and don't require mathematical operations (for example, account numbers, serial numbers, or other identifiers), convert the column values to text strings using the Text function.

Number formats

Number data can be displayed in the following formats:

Custom number format

In addition to the default number format options, you can configure a custom number format for your data. For a given number column, use the toolbar or the column menu to select Format () > Custom number..., then configure a custom format:

• Use d3-format syntax to define a format string. For example:
  • .2s to display SI notation and two significant digits: 1.2k
  • .0% to display a rounded percentage: 123456%
  • #x to display prefixed hexadecimal: 0x4d3
• Specify a currency, decimal, or digit grouping symbol to use.
• Set a standard prefix or suffix for a number type.
• Set a constant to display null values as.

Date

The date data type supports structured date values that represent specific points in time.

Sigma presents date and time relative to your organization’s default time zone. To display the data in a different time zone, use the ConvertTimezone function.

For a list of functions provided to operate on date data, see Date functions overview.

Date formats

Date data can be displayed in the following formats:

You can also configure custom date formats. For more information, see Define custom date formats.

Logical

The logical data type supports structured Boolean values (true or false) that represent binary or conditional states.

Logical formats

Logical data can be displayed in the following formats:

Variant

The variant data type supports semi-structured data that represents one or more values of other data types, including text, number, and date.

All semi-structured data (including variant, array, and object types) in your connected CDW or DBMS map to Sigma’s variant data type.

Variant formats

Variant data can be displayed in the following formats:

Geography

The geography data type supports structured spatial data that represents geographic locations or features.

You can perform geospatial joins on geography data using the "intersect" and "within" operators:

Intersect

Returns rows from both datasets where geospatial objects intersect or overlap

Within

Returns rows where geospatial objects in one dataset are contained entirely within geospatial objects of the other

📘

The geography data type is available with Snowflake and BigQuery connections only. Sigma retrieves WKT data and other geospatial formats (excluding GeoJSON) from other CDW or DBMS connections, but it's presented as the text data type.

For a list of functions provided to operate on geography data, see Geography functions overview.

Geography formats

Geography data can be displayed in the following formats: