| 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)];; |
| } |
| } |