Data type and format support

Sigma supports various data types and formats to facilitate effective analysis and reporting. Data types apply to retrieved1 and direct input2 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:

TextStrings of characters that represent textual information
NumberNumerical digits that represent numeric values or quantitative information
DateDate values that represents specific periods or points in time
LogicalBoolean values (true or false) that represent binary or conditional states
VariantSemi-structured data that represents one or more values of other data types
GeographySpatial data that represents geographic locations or features

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.

πŸ’‘

When 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:

FormatExample
Plain text1234.56
Number1,234.56
Percent12.34%
Scientific1.23e4
SI units1.2k
Currency$1234.56
Financial(1,234.56)
Whole number1,234

You can also configure custom number formats based on the d3-format module.

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:

FormatExample
Date01/31/2023
ISO date2023-01-31
Long dateJanuary 31, 2023
Month yearJan 2023
Date time01/31/2023 03:04:05 PM
ISO date time2023-01-31 15:05:05
Time03:04 PM

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:

FormatExample
Booleantrue

false

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:

FormatExample
JSON{"name":"Alex Lee","age":30,"email":"[email protected]"}
GeoJSON{"type":"Feature","geometry":{"type":"Point","coordinates":[-73.98, 40.74]},"properties":{"name":"Empire State Building","category":"Landmark"}}

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:

FormatExample
Well-known text
(WKT)
POINT (10 20)

LINESTRING (30 40, 50 60, 70 80)

POLYGON ((0 0, 10 0, 10 10, 0 10, 0 0))

MULTIPOINT (10 20, 30 40, 50 60)

MULTILINESTRING ((0 0, 10 10, 20 20), (30 30, 40 40, 50 50))

MULTIPOLYGON (((0 0, 10 0, 10 10, 0 10, 0 0)), ((20 20, 30 20, 30 30, 20 30, 20 20)))