commit 97153b9e2f1466fbf639fffaef134cb2e1a6b54d
author Henry Deist <hdeist@google.com> Fri Apr 22 22:13:30 2022 +0000
committer Henry Deist <hdeist@google.com> Fri Jul 29 19:06:49 2022 +0000
tree 7689253dd820b1a71dbc8277110f6955bd301b9a
parent 7af4a79525e0f32458c726b0b07913a8423d1631

Add nal and customers to revenue explore

explores/revenue.view.lkml

diff --git a/explores/revenue.view.lkml b/explores/revenue.view.lkml
index 533328e..b48013d 100644
--- a/explores/revenue.view.lkml
+++ b/explores/revenue.view.lkml
@@ -1,5 +1,7 @@
 # Approximates https://lookercs-internal.git.corp.google.com/cloud_sales_bi/+/refs/heads/master/explores/revenue.view.lkml
 include: "/views/revenue/*.view.lkml"
+include: "/views/nal.view.lkml"
+include: "/views/vector/customers.view.lkml"
 
 explore: revenue {
   label: "Usage Revenue"
@@ -12,8 +14,26 @@
       , revenue.service_family: "CLOUD"
     ]
   }
+
+  join: vector_customers {
+    view_label: "Account"
+    sql_on: ${revenue.sfdc_account_id} = ${vector_customers.sfdc_account_id};;
+    relationship: many_to_one
+    fields: [vector_customers.digital_native_details*
+      , vector_customers.nal_sub_cluster
+      , vector_customers.account_name
+      , vector_customers.count_sfdc_account_id
+      , vector_customers.is_isv]
+  }
+
   join: max_date {
     type: cross
     relationship: one_to_one
   }
+  join: nal {
+    view_label: "Account"
+    type: left_outer
+    sql_on: ${revenue.nal_id} = ${nal.nal_id} ;;
+    relationship: many_to_one
+  }
 }