Add nal and customers to revenue explore
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 + } }