gcp_billing_export_core.explore.lkml

explore: gcp_billing_export_core {
  extension: required
  view_label: "GCP Billing"
  label: "GCP Billing"

  join: gcp_billing_export_project {
    view_label: "GCP Billing"
    sql: LEFT JOIN UNNEST([${gcp_billing_export.project}]) AS gcp_billing_export_project ;;
    relationship: one_to_one
  }

  join: gcp_billing_export_labels {
    view_label: "GCP Billing"
    relationship: one_to_many
    sql: LEFT JOIN UNNEST(project.labels) AS gcp_billing_export_labels ;;
  }

  join: gcp_billing_export_usage {
    view_label: "GCP Billing"
    sql: LEFT JOIN UNNEST([${gcp_billing_export.usage}]) AS gcp_billing_export_usage ;;
    relationship: one_to_one
  }

  join: gcp_billing_export_credits {
    view_label: "GCP Billing"
    sql: LEFT JOIN UNNEST(credits) AS gcp_billing_export_credits ;;
    relationship: one_to_many
  }

  join: gcp_billing_export_service {
    view_label: "GCP Billing"
    relationship: one_to_one
    sql: LEFT JOIN UNNEST([${gcp_billing_export.service}]) AS gcp_billing_export_service ;;
  }

  join: gcp_billing_export_sku {
    view_label: "GCP Billing"
    relationship: one_to_one
    sql: LEFT JOIN UNNEST([${gcp_billing_export.sku}]) AS gcp_billing_export_sku ;;
  }

  join: project_name_sort {
    relationship: many_to_one
    sql_on: ${gcp_billing_export_project.name} = ${project_name_sort.name}  ;;
  }

  join: service_name_sort {
    relationship: many_to_one
    sql_on: ${gcp_billing_export_service.description} = ${service_name_sort.name} ;;
  }
}