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