| ######################################################## |
| # |
| # Author: paolarenteria@ |
| # Updated Date: 2021-12-10 |
| # Imports the nals_view table for NAL metadata |
| # |
| ######################################################## |
| view: nal { |
| # sql_table_name: `concord-prod.service_gcc.nals_view` ;; |
| derived_table: { |
| sql: SELECT |
| 1 nal_id |
| , false is_dn_nal |
| , 'field_rep' field_rep |
| , 'access_key_hierarchy' access_key_hierarchy |
| , 'fsr_manager' fsr_manager |
| , false is_digital_native |
| , 'nal_sub_cluster' nal_sub_cluster |
| , 'nal_tag' nal_tag |
| , false is_street_level_nal |
| , 'micro_region' micro_region |
| , 'nal_cluster' nal_cluster |
| , 'nal_name' nal_name |
| , 'nal_type' nal_type |
| , 'nal_vertical' nal_vertical |
| , 'region' region |
| , 'sub_region' sub_region;; |
| } |
| |
| ##### PRIMARY KEY ##### |
| dimension: nal_id { |
| label: "NAL ID" |
| hidden: yes |
| primary_key: yes |
| type: number |
| sql: ${TABLE}.nal_id ;; |
| } |
| ##### DIMENSIONS ##### |
| dimension: digital_native { |
| group_label: "NAL Details" |
| label: "Digital Native" |
| description: "A string version of \"Is Digital Native NAL\" that is Digital Native or Traditional" |
| type: string |
| sql: IF(${is_dn_nal}, "Digital Native", "Traditional") ;; |
| } |
| dimension: field_rep { |
| group_label: "NAL People" |
| description: "LDAP of the Field Rep" |
| type: string |
| sql: ${TABLE}.field_rep ;; |
| link: { |
| label: "MOMA" |
| url: "https://moma.corp.google.com/person/{{ value }}" |
| } |
| } |
| dimension: field_rep_manager { |
| group_label: "NAL People" |
| description: "LDAP of the Field Rep's Manager" |
| type: string |
| sql: ${TABLE}.fsr_manager ;; |
| link: { |
| label: "MOMA" |
| url: "https://moma.corp.google.com/person/{{ value }}" |
| } |
| } |
| dimension: is_dn_nal { |
| group_label: "NAL Details" |
| label: "Is Digital Native NAL" |
| type: yesno |
| sql: ${TABLE}.is_digital_native ;; |
| } |
| dimension: is_prime_nal { |
| group_label: "NAL Details" |
| label: "Is Prime NAL" |
| type: yesno |
| sql: ${TABLE}.nal_tag = "Prime" ;; |
| } |
| dimension: is_street_level_nal { |
| group_label: "NAL Details" |
| label: "Is Street Level NAL" |
| type: yesno |
| sql: ${TABLE}.is_street_level_nal ;; |
| } |
| dimension: micro_region { |
| description: "Micro region" |
| hidden: yes |
| sql: ${TABLE}.micro_region ;; |
| } |
| dimension: nal_cluster { |
| description: "NAL cluster" |
| hidden: yes |
| sql: ${TABLE}.nal_cluster ;; |
| } |
| dimension: nal_name { |
| description: "NAL name" |
| hidden: yes |
| sql: ${TABLE}.nal_name ;; |
| } |
| dimension: nal_segment { |
| group_label: "{% if _explore._name == 'gcp_forecast_quotas_transformed' %}Region{% else %}NAL Details{% endif %}" |
| label: "NAL Segment" |
| type: string |
| sql: ${TABLE}.nal_type ;; |
| } |
| dimension: nal_vertical { |
| group_label: "NAL Details" |
| label: "NAL Vertical" |
| type: string |
| sql: ${TABLE}.nal_vertical ;; |
| } |
| dimension: region { |
| description: "NAL region" |
| hidden: yes |
| sql: ${TABLE}.region ;; |
| } |
| dimension: sub_region { |
| description: "NAL sub region" |
| hidden: yes |
| sql: ${TABLE}.sub_region ;; |
| } |
| } |
