connection: "youtube-looker"

include: "/views/youtube_audit_tool/AUDITS.view.lkml"
include: "/views/youtube_audit_tool/AUDITS_FLAGS.view.lkml"
include: "/views/youtube_audit_tool/AUDITS_GROUPS.view.lkml"
include: "/views/youtube_audit_tool/AUDITS_LOG.view.lkml"
include: "/views/youtube_audit_tool/AUDITS_META.view.lkml"
include: "/views/youtube_audit_tool/AUDITS_ROWS.view.lkml"
include: "/views/youtube_audit_tool/AUDITS_ROWS_ROWTYPES.view.lkml"
include: "/views/youtube_audit_tool/AUDITS_ROWTYPES.view.lkml"
include: "/views/youtube_audit_tool/USERS.view.lkml"
include: "/views/youtube_audit_tool/yt_avod_revenue_views.view.lkml"
include: "/views/youtube_audit_tool/yt_svod_revenue_views.view.lkml"

explore: audits {
  hidden: no
  label: "YouTube Audit Tool"
  view_label: "Audits"

  join: audits_flags {
    sql_on: ${audits_flags.audit} = ${audits.id};;
    relationship: one_to_many
    view_label: "Audits"
  }

  join: audits_groups {
    sql_on: ${audits_groups.id} = ${audits.group};;
    relationship: many_to_one
    view_label: "Audits"
  }

  join: audits_log {
    sql_on: ${audits_log.audit} = ${audits.id};;
    relationship: one_to_many
    view_label: "Audits"
  }

  join: audits_meta {
    sql_on: ${audits_meta.audit} = ${audits.id};;
    relationship: one_to_many
    view_label: "Audits"
  }

  join: audits_rows {
    sql_on: ${audits_rows.audit} = ${audits.id};;
    relationship: one_to_many
    view_label: "Audits"
  }

  join: audits_rows_rowtypes {
    sql_on: ${audits_rows_rowtypes.row_id} = ${audits_rows.id};;
    relationship: many_to_one
    view_label: "Audits"
  }

  join: audits_rowtypes {
    sql_on: ${audits_rowtypes.id} = ${audits_rows_rowtypes.rowtype_id};;
    relationship: many_to_one
    view_label: "Audits"
  }

  join: users {
    sql_on: ${users.id} = ${audits_log.user};;
    relationship: many_to_one
    view_label: "Audits"
  }

  join: yt_avod_revenue_views {
    sql_on: ${yt_avod_revenue_views.isrc} = ${audits_flags.isrc};;
    relationship: many_to_many
    view_label: "AVOD Revenue/Views"
  }

  join: yt_svod_revenue_views {
    sql_on: ${yt_svod_revenue_views.isrc} = ${audits_flags.isrc};;
    relationship: many_to_many
    view_label: "SVOD Revenue/Views"
  }
}