blob: 5056e859673c2344342bbda9a5783944b2fc3264 [file] [log] [blame] [edit]
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: product_line {
description: "product_line"
type: string
sql: ${TABLE}.product_line ;;
}
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: replace('{{_user_attributes['email'] }}', '@google.com', '');;
}
}