blob: ef42ed3b502f6c57134803b5e7fe71900b19a9c5 [file] [log] [blame]
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)];;
}
}