CreateQuery tab (children 3)
 Identifier tab
 Columns definition (children 2)
  ExpressionList (children 82)
   ColumnDeclaration country (children 2)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType FixedString (children 1)
       ExpressionList (children 1)
        Literal UInt64_7
    Literal \'unknown\'
   ColumnDeclaration city (children 2)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType String
    Literal \'unknown\'
   ColumnDeclaration region (children 2)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType String
    Literal \'unknown\'
   ColumnDeclaration continent (children 2)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType FixedString (children 1)
       ExpressionList (children 1)
        Literal UInt64_7
    Literal \'unknown\'
   ColumnDeclaration is_eu_country (children 1)
    DataType Bool
   ColumnDeclaration date (children 2)
    DataType DateTime
    Function CODEC (children 1)
     ExpressionList (children 2)
      Function DoubleDelta
      Function LZ4
   ColumnDeclaration viewer_date (children 2)
    DataType DateTime
    Function toTimezone (children 1)
     ExpressionList (children 2)
      Identifier date
      Identifier timezone
   ColumnDeclaration device_browser (children 2)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType String
    Literal \'unknown\'
   ColumnDeclaration metro_code (children 2)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType String
    Literal \'unknown\'
   ColumnDeclaration domain (children 2)
    DataType String
    Literal \'unknown\'
   ColumnDeclaration device_platform (children 2)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType String
    Literal \'unknown\'
   ColumnDeclaration device_type (children 2)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType String
    Literal \'unknown\'
   ColumnDeclaration device_vendor (children 2)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType String
    Literal \'unknown\'
   ColumnDeclaration ip (children 2)
    DataType FixedString (children 1)
     ExpressionList (children 1)
      Literal UInt64_39
    Literal \'unknown\'
   ColumnDeclaration lat (children 2)
    DataType Decimal (children 1)
     ExpressionList (children 2)
      Literal UInt64_8
      Literal UInt64_6
    Function CODEC (children 1)
     ExpressionList (children 1)
      Function T64
   ColumnDeclaration lng (children 2)
    DataType Decimal (children 1)
     ExpressionList (children 2)
      Literal UInt64_9
      Literal UInt64_6
    Function CODEC (children 1)
     ExpressionList (children 1)
      Function T64
   ColumnDeclaration asset_id (children 2)
    DataType String
    Literal \'unknown\'
   ColumnDeclaration is_personalized (children 1)
    DataType Bool
   ColumnDeclaration metric (children 1)
    DataType String
   ColumnDeclaration origin (children 2)
    DataType String
    Literal \'unknown\'
   ColumnDeclaration product_id (children 2)
    DataType UInt64
    Function CODEC (children 1)
     ExpressionList (children 1)
      Function T64
   ColumnDeclaration referer (children 2)
    DataType String
    Literal \'unknown\'
   ColumnDeclaration server_side (children 2)
    DataType Int8
    Function CODEC (children 1)
     ExpressionList (children 1)
      Function T64
   ColumnDeclaration third_party_id (children 2)
    DataType String
    Literal \'unknown\'
   ColumnDeclaration partner_slug (children 2)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType FixedString (children 1)
       ExpressionList (children 1)
        Literal UInt64_10
    Literal \'unknown\'
   ColumnDeclaration user_agent (children 2)
    DataType String
    Literal \'unknown\'
   ColumnDeclaration user_id (children 1)
    DataType UUID
   ColumnDeclaration zip (children 2)
    DataType FixedString (children 1)
     ExpressionList (children 1)
      Literal UInt64_10
    Literal \'unknown\'
   ColumnDeclaration timezone (children 1)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType String
   ColumnDeclaration as_organization (children 2)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType String
    Literal \'unknown\'
   ColumnDeclaration content_cat (children 1)
    DataType Array (children 1)
     ExpressionList (children 1)
      DataType String
   ColumnDeclaration playback_method (children 2)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType String
    Literal \'unknown\'
   ColumnDeclaration store_id (children 2)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType String
    Literal \'unknown\'
   ColumnDeclaration store_url (children 2)
    DataType String
    Literal \'unknown\'
   ColumnDeclaration timestamp (children 1)
    DataType Nullable (children 1)
     ExpressionList (children 1)
      DataType DateTime
   ColumnDeclaration ad_count (children 2)
    DataType Int8
    Function CODEC (children 1)
     ExpressionList (children 1)
      Function T64
   ColumnDeclaration ad_type (children 2)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType FixedString (children 1)
       ExpressionList (children 1)
        Literal UInt64_10
    Literal \'unknown\'
   ColumnDeclaration ad_categories (children 1)
    DataType Array (children 1)
     ExpressionList (children 1)
      DataType FixedString (children 1)
       ExpressionList (children 1)
        Literal UInt64_8
   ColumnDeclaration blocked_ad_categories (children 1)
    DataType Array (children 1)
     ExpressionList (children 1)
      DataType FixedString (children 1)
       ExpressionList (children 1)
        Literal UInt64_8
   ColumnDeclaration break_max_ad_length (children 2)
    DataType Int8
    Function CODEC (children 1)
     ExpressionList (children 1)
      Function T64
   ColumnDeclaration break_max_ads (children 2)
    DataType Int8
    Function CODEC (children 1)
     ExpressionList (children 1)
      Function T64
   ColumnDeclaration break_max_duration (children 2)
    DataType Int8
    Function CODEC (children 1)
     ExpressionList (children 1)
      Function T64
   ColumnDeclaration break_min_ad_length (children 2)
    DataType Int8
    Function CODEC (children 1)
     ExpressionList (children 1)
      Function T64
   ColumnDeclaration break_position (children 2)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType FixedString (children 1)
       ExpressionList (children 1)
        Literal UInt64_18
    Literal \'unknown\'
   ColumnDeclaration media_playhead (children 2)
    DataType String
    Literal \'unknown\'
   ColumnDeclaration placement_type (children 2)
    DataType Int8
    Function CODEC (children 1)
     ExpressionList (children 1)
      Function T64
   ColumnDeclaration transaction_id (children 1)
    DataType String
   ColumnDeclaration universal_ad_id (children 1)
    DataType Array (children 1)
     ExpressionList (children 1)
      DataType String
   ColumnDeclaration client_ua (children 2)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType String
    Literal \'unknown\'
   ColumnDeclaration device_ip (children 2)
    DataType FixedString (children 1)
     ExpressionList (children 1)
      Literal UInt64_39
    Literal \'unknown\'
   ColumnDeclaration device_ua (children 2)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType String
    Literal \'unknown\'
   ColumnDeclaration ifa (children 1)
    DataType String
   ColumnDeclaration ifa_type (children 2)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType String
    Literal \'unknown\'
   ColumnDeclaration vast_lat (children 2)
    DataType Decimal (children 1)
     ExpressionList (children 2)
      Literal UInt64_8
      Literal UInt64_6
    Function CODEC (children 1)
     ExpressionList (children 1)
      Function T64
   ColumnDeclaration vast_long (children 2)
    DataType Decimal (children 1)
     ExpressionList (children 2)
      Literal UInt64_9
      Literal UInt64_6
    Function CODEC (children 1)
     ExpressionList (children 1)
      Function T64
   ColumnDeclaration server_ua (children 2)
    DataType String
    Literal \'unknown\'
   ColumnDeclaration app_bundle (children 2)
    DataType String
    Literal \'unknown\'
   ColumnDeclaration page_url (children 2)
    DataType String
    Literal \'unknown\'
   ColumnDeclaration api_framework (children 1)
    DataType Array (children 1)
     ExpressionList (children 1)
      DataType UInt8
   ColumnDeclaration click_type (children 1)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType String
   ColumnDeclaration extensions (children 1)
    DataType Array (children 1)
     ExpressionList (children 1)
      DataType String
   ColumnDeclaration media_mime (children 1)
    DataType Array (children 1)
     ExpressionList (children 1)
      DataType String
   ColumnDeclaration om_id_partner (children 2)
    DataType LowCardinality (children 1)
     ExpressionList (children 1)
      DataType String
    Literal \'unknown\'
   ColumnDeclaration player_capabilities (children 1)
    DataType Array (children 1)
     ExpressionList (children 1)
      DataType FixedString (children 1)
       ExpressionList (children 1)
        Literal UInt64_12
   ColumnDeclaration vast_versions (children 1)
    DataType Array (children 1)
     ExpressionList (children 1)
      DataType UInt8
   ColumnDeclaration verification_vendors (children 1)
    DataType Array (children 1)
     ExpressionList (children 1)
      DataType String
   ColumnDeclaration ad_play_head (children 2)
    DataType String
    Literal \'unknown\'
   ColumnDeclaration ad_serving_id (children 2)
    DataType String
    Literal \'unknown\'
   ColumnDeclaration asset_uri (children 2)
    DataType String
    Literal \'unknown\'
   ColumnDeclaration content_id (children 2)
    DataType String
    Literal \'unknown\'
   ColumnDeclaration content_uri (children 2)
    DataType String
    Literal \'unknown\'
   ColumnDeclaration inventory_state (children 1)
    DataType Array (children 1)
     ExpressionList (children 1)
      DataType FixedString (children 1)
       ExpressionList (children 1)
        Literal UInt64_14
   ColumnDeclaration player_size (children 1)
    DataType Array (children 1)
     ExpressionList (children 1)
      DataType UInt8
   ColumnDeclaration player_state (children 1)
    DataType Array (children 1)
     ExpressionList (children 1)
      DataType FixedString (children 1)
       ExpressionList (children 1)
        Literal UInt64_12
   ColumnDeclaration pod_sequence (children 2)
    DataType Int8
    Function CODEC (children 1)
     ExpressionList (children 1)
      Function T64
   ColumnDeclaration click_position (children 1)
    DataType Array (children 1)
     ExpressionList (children 1)
      DataType UInt32
   ColumnDeclaration error_code (children 2)
    DataType Int16
    Function CODEC (children 1)
     ExpressionList (children 1)
      Function T64
   ColumnDeclaration error_reason (children 2)
    DataType Int8
    Function CODEC (children 1)
     ExpressionList (children 1)
      Function T64
   ColumnDeclaration gdpr_consent (children 2)
    DataType String
    Literal \'unknown\'
   ColumnDeclaration limited_tracking (children 1)
    DataType Bool
   ColumnDeclaration regulations (children 2)
    DataType String
    Literal \'unknown\'
   ColumnDeclaration content_category (children 1)
    DataType Array (children 1)
     ExpressionList (children 1)
      DataType String
  ExpressionList (children 1)
   Projection (children 1)
    ProjectionSelectQuery (children 2)
     ExpressionList (children 1)
      Asterisk
     Function tuple (children 1)
      ExpressionList (children 4)
       Function toYYYYMMDD (children 1)
        ExpressionList (children 1)
         Identifier date
       Identifier metric
       Identifier product_id
       Identifier asset_id
 Storage definition (children 2)
  Function MergeTree
  Function tuple (children 1)
   ExpressionList (children 4)
    Identifier product_id
    Identifier metric
    Identifier asset_id
    Function toYYYYMMDD (children 1)
     ExpressionList (children 1)
      Identifier date