connection: "snowflake-looker-external"

include: "/views/Communion/*.view.lkml"
include: "/views/Facts/facts_prod_dim_country.view.lkml"

explore: int_dbt_prod_communion_amazon_daily_data {
  label: "Communion Amazon Daily Data"
  hidden: yes

  join: facts_prod_dim_country {
    view_label: "Transaction Country"
    relationship: many_to_one
    sql_on: ${int_dbt_prod_communion_amazon_daily_data.country_code} = ${facts_prod_dim_country.country_code} ;;
  }
}

explore: int_dbt_prod_communion_spotify_daily_data {
  label: "Communion Spotify Daily Data"
  hidden: yes

  join: facts_prod_dim_country {
    view_label: "Transaction Country"
    relationship: many_to_one
    sql_on: ${int_dbt_prod_communion_spotify_daily_data.country_code} = ${facts_prod_dim_country.country_code} ;;
  }
}

explore: int_dbt_prod_communion_apple_daily_data {
  label: "Communion Apple Daily Data"
  hidden: yes

  join: facts_prod_dim_country {
    view_label: "Transaction Country"
    relationship: many_to_one
    sql_on: ${int_dbt_prod_communion_apple_daily_data.country_code} = ${facts_prod_dim_country.country_code} ;;
  }
}

explore: int_dbt_prod_communion_tiktok_socials {
  label: "Communion TikTok Data"
  hidden: yes
}

explore: int_dbt_prod_communion_youtube_socials {
  label: "Communion YouTube Data"
  hidden: yes
}

explore: int_dbt_prod_communion_instagram_creations_socials {
  label: "Communion Instagram Creations Data"
  hidden: yes

    join: facts_prod_dim_country {
    view_label: "Transaction Country"
    relationship: many_to_one
    sql_on: ${int_dbt_prod_communion_instagram_creations_socials.country_code} = ${facts_prod_dim_country.country_code} ;;
  }
}

explore: int_dbt_prod_communion_instagram_views_socials {
  label: "Communion Instagram Views Data"
  hidden: yes

  join: facts_prod_dim_country {
    view_label: "Transaction Country"
    relationship: many_to_one
    sql_on: ${int_dbt_prod_communion_instagram_views_socials.country_code} = ${facts_prod_dim_country.country_code} ;;
  }
}