sql

The core declaration of the field definition. Best practice dictates using field references over raw database columns when calling other fields/dimensions. Note that dimensions can only be derived from other dimensions, unlike measures.

Syntax

<dimension_name>:
  sql: <sql_expression>

Properties

dimension_name

object

The name of the dimension. Dimension names must:

Be unique within the view
Start with a letter
Contain only alphanumeric characters and underscores

Hide dimension_name properties

sql

string

A SQL expression that defines the dimension. If the SQL includes protected words (e.g., group), include them with the following syntax: "`group`"Field type is implicit in Omni, and defined based upon the underlying field’s database type. To change the type, CAST the field (for example, sql: ${zip_code}::string).

When referencing other fields, use Omni field references (${view.name}) instead of the raw database name. For example, ${orders.id}

DO NOT PARSE (special argument)

DO NOT PARSE is a special argument used to stop Omni’s parser from interpreting and validating the SQL. This should be used in the rare circumstance that Omni is not saving valid SQL in the model, which can happen when obscure, dialect-specific SQL is used.

DO NOT PARSE usage

<dimension_name>:
  sql: |-
    -- DO NOT PARSE
    <sql_expression>
crazy_sql:
  sql: |-
    -- DO NOT PARSE
    function_that_is_weird(${field})

Examples

Concatenated fields

full_name:
  sql: CONCAT(${users.first_name}, ' ', ${users.last_name})

Calculated margin

margin:
  sql: ${order_items.sale_price} - ${products.cost}

Case statement

is_special_date:
  sql: |-
    CASE
      WHEN ${orders.created_at[date]} >= '2022-04-14' AND ${orders.created_at[date]} <= '2022-05-09'
      THEN 'Mothers Day 2022'
      WHEN ${orders.created_at[date]} >= '2022-05-26' AND ${orders.created_at[date]} <= '2022-06-20'
      THEN 'Fathers Day 2022'
      ELSE 'Other'
    END

DO NOT PARSE usage

state_sentiment:
  sql: |-
    -- DO NOT PARSE
    SNOWFLAKE.CORTEX.SENTIMENT(${states.state})::float

Type casting

zip_code_string:
  sql: ${zip_code}::string

skip_parent_label

suggest_from_field

⌘I

Getting started

Manage content

Analyze & build

Visualize & present

Deliver content

Model data

Manage integrations

Syntax

Properties

DO NOT PARSE (special argument)

Examples

​Syntax

​Properties

​DO NOT PARSE (special argument)

​Examples

Syntax

Properties

DO NOT PARSE (special argument)

Examples