version: 2
sources:
- name: youtube
  database: prod
  schema: yt_reports_api
  tables:
# please retain alphabetical order for source table names

  - name: assetbasic_intermediate
    description: youtube report asset_intermediate
    tests:
    - not_transient:
        config:
          severity: warn
    - clustered:
        by: channel_id, video_id, asset_id
        config:
          severity: warn

  - name: assetcombined_intermediate
    description: youtube report asset_combined
    tests:
    - not_transient

  - name: useractivity_intermediate
    description: youtube video report for user activity
    tests:
    - not_transient

  - name: playbacklocation_intermediate
    description: youtube video report for playback location
    tests:
    - not_transient

  - name: trafficsource_intermediate
    description: youtube video report for traffic source
    tests:
    - not_transient

  - name: deviceos_intermediate
    description: youtube video report for device type and operating systems
    tests:
    - not_transient

  - name: demographics_intermediate
    description: youtube video report for user demographics
    tests:
    - not_transient

  - name: sharingservice_intermediate
    description: youtube video report sharing services
    tests:
    - not_transient

  - name: annotations_intermediate
    description: youtube video report for annotatoin usage
    tests:
    - not_transient

  - name: cards_intermediate
    description: youtube video report for cards enagement
    tests:
    - not_transient

  - name: subtitles_intermediate
    description: youtube video report for subtitle usage
    tests:
    - not_transient


  - name: combined_intermediate
    description: youtube video report for combined dimensions (playback location, traffic source, etc.)
    tests:
    - not_transient

  - name: assetprovince_intermediate
    description: youtube asset report for user activity with state/province level granualarity
    tests:
    - not_transient

  - name: assetplaybacklocation_intermediate
    description: youtube asset report for playback location
    tests:
    - not_transient

  - name: assettrafficsource_intermediate
    description: youtube asset report for traffic source
    tests:
    - not_transient

  - name: assetdeviceos_intermediate
    description: youtube asset report for device type and operating system
    tests:
    - not_transient
  
  - name: assetdemographics_intermediate
    description: youtube asset report for user demographics
    tests:
    - not_transient

  - name: assetsharingservice_intermediate
    description: youtube asset report for sharing serviecs
    tests:
    - not_transient


  - name: assetannotations_intermediate
    description: youtube asset for report annotations
    tests:
    - not_transient


  - name: assetcards_intermediate
    description: youtube asset report for cards
    tests:
    - not_transient

  - name: playlistcombined_intermediate
    description: youtube playlist report for videos
    tests:
    - not_transient