nal

explores/nal.view.lkml

diff --git a/explores/nal.view.lkml b/explores/nal.view.lkml
new file mode 100644
index 0000000..db13c4e
--- /dev/null
+++ b/explores/nal.view.lkml
@@ -0,0 +1,8 @@
+include: "/views/nal.view.lkml"
+# Last Updated: March 2022
+# Created by: paoalrenteria@
+# Purpose: Defines a NAL Explore to be used to improve query performance for filter suggestions
+explore: nal {
+  hidden: yes
+  description: "Surfaces NAL table data and is used explicitly for filter suggestions"
+}

explores/vector_customers.view.lkml

diff --git a/explores/vector_customers.view.lkml b/explores/vector_customers.view.lkml
index 78626d3..ed5bbcf 100644
--- a/explores/vector_customers.view.lkml
+++ b/explores/vector_customers.view.lkml
@@ -1,17 +1,17 @@
 include: "/views/vector/customers.view.lkml"
-# include: "/views/nal.view.lkml"
+include: "/views/nal.view.lkml"
 # include: "/views/revenue/account_sort.view.lkml"
 # include: "/views/account_stats.view.lkml"
 # include: "/views/apac_account_metadata.view.lkml"
 explore: vector_customers {
   view_label: "Account"
   description: "Contains data on vector customers sourced from Vector, Anaplan and MDM"
-  # join: nal {
-  #   view_label: "Account"
-  #   sql_on: ${vector_customers.nal_id} = ${nal.nal_id} ;;
-  #   type: left_outer
-  #   relationship: many_to_one
-  # }
+  join: nal {
+    view_label: "Account"
+    sql_on: ${vector_customers.nal_id} = ${nal.nal_id} ;;
+    type: left_outer
+    relationship: many_to_one
+  }
   # join: account_sort {
   #   type: left_outer
   #   sql: ${vector_customers.reporting_id} = ${account_sort.reporting_id} ;;

views/nal.view.lkml

diff --git a/views/nal.view.lkml b/views/nal.view.lkml
new file mode 100644
index 0000000..0734ce3
--- /dev/null
+++ b/views/nal.view.lkml
@@ -0,0 +1,121 @@
+########################################################
+#
+# 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 ;;
+  }
+}