commit c1d4ce8dd30f070364039ac1b98cbaad0aea328c
author hdeist hdeist <hdeist@google.com> Tue Apr 11 00:55:56 2023 +0000
committer hdeist hdeist <hdeist@google.com> Tue Apr 11 17:23:06 2023 +0000
tree 51bf929a23d5b9a62d5975f70d1ce346dceeaa6b
parent 124d4611d92bcd87d8e194a606d47471adadc933

Create explore gcc_revenue_partitioned

Change-Id: I91e867ce6ab382e84b468ebe6586638d2699dba7

explores/gcc_revenue_partitioned.view.lkml

diff --git a/explores/gcc_revenue_partitioned.view.lkml b/explores/gcc_revenue_partitioned.view.lkml
new file mode 100644
index 0000000..5115d12
--- /dev/null
+++ b/explores/gcc_revenue_partitioned.view.lkml
@@ -0,0 +1,5 @@
+
+include: "/views/revenue/gcc_revenue_partitioned.view.lkml"
+explore: gcc_revenue_partitioned {
+  sql_always_where: ${access_key_hierarchy} like '%hdeist%' ;;
+}

views/revenue/gcc_revenue_partitioned.view.lkml

diff --git a/views/revenue/gcc_revenue_partitioned.view.lkml b/views/revenue/gcc_revenue_partitioned.view.lkml
new file mode 100644
index 0000000..ef42ed3
--- /dev/null
+++ b/views/revenue/gcc_revenue_partitioned.view.lkml
@@ -0,0 +1,37 @@
+view: gcc_revenue_partitioned {
+
+  sql_table_name: `concord-test.stagingservice_gccinternal.gcc_revenue_partitioned` ;;
+
+  dimension: partition_date {
+    description: "partition_date"
+    type: string
+    sql: ${TABLE}.partition_date ;;
+  }
+
+  dimension: billing_account_id {
+    description: "billing_account_id"
+    type: string
+    sql: ${TABLE}.billing_account_id ;;
+  }
+  dimension: access_key_hierarchy {
+    description: "access_key_hierarchy"
+    type: string
+    sql: ${TABLE}.access_key_hierarchy ;;
+  }
+  dimension: usd_revenue_net {
+    description: "usd_revenue_net"
+    type: number
+    sql: ${TABLE}.usd_revenue_net ;;
+  }
+  dimension: session_user {
+    description: "session_user"
+    type: string
+    sql: SESSION_USER() ;;
+  }
+
+  dimension: ldap {
+    description: "ldap"
+    type: string
+    sql: SPLIT('{{_user_attributes['email'] }}', "@")[SAFE_OFFSET(0)];;
+  }
+}