Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.omni.co/llms.txt

Use this file to discover all available pages before exploring further.

When set to false, the field will default to the connection (database) timezone with no conversion. This parameter can only be added to a dimension and will apply to all the parameterizations of the dimension. Date or week fields in the database are good candidates for this parameter, as converting the time segments isn’t necessary.
Timezone conversion in a sql parameter is strongly discouraged. This approach can create challenges on SQL generation for complex transformations, such as dimension fill vis-a-vis timezones.

​
Syntax

<dimension_name>:
  convert_tz: false

​
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

​
Examples

Disable timezone conversion
created_date:
  sql: created_date
  convert_tz: false
Date field with timeframes
timestamp_created_pst:
  sql: DATETIME(${marketing_orders_new.timestamp_created}, 'America/Los_Angeles')
  timeframes:
    - DATE
    - HOUR_OF_DAY
    - MONTH_NAME
  convert_tz: false