connection: "youtube-looker"

include: "/views/yt_claim_facts_prod_staging_raw_youtube_claim.view.lkml"
include: "/views/int_dbt_prod_youtube_shorts.view.lkml" # include all views in the views/ folder in this project
# include: "/**/*.view.lkml"                 # include all views in this project
# include: "my_dashboard.dashboard.lookml"   # include a LookML dashboard called my_dashboard

# # Select the views that should be a part of this model,
# # and define the joins that connect them together.
explore: yt_claim_facts_prod_staging_raw_youtube_claim {
  label: "YouTube Shorts v2"
  case_sensitive: no

  # Temporarily comment this out to see if data returns
  # sql_always_where: ${int_dbt_prod_youtube_shorts.isrc} IS NOT NULL ;;

  join: int_dbt_prod_youtube_shorts {
    view_label: "Shorts"
    type: left_outer  # Changed from inner
    relationship: many_to_one # Usually more accurate for claims
    sql_on: ${int_dbt_prod_youtube_shorts.video_id} = ${yt_claim_facts_prod_staging_raw_youtube_claim.video_id} ;;
  }
}