local:
  temp_folder: /mnt/data/tmp/exportAnalyticsRawFilesDirectory/Youtube_weekly
  import_folder: /mnt/data/tmp/importAnalyticsRawFilesDirectory/Youtube_weekly
s3:
  bucket: cucumbers
  download_folder: Youtube_weekly/downloads
  archives_folder: Youtube_weekly/archives
  import_folder: Youtube_weekly/to_be_imported_into_redshift
expected_number_of_files: 2
check_num_of_files: true
store_id: 45305
raw_table_name: staging_raw_youtube
import_options:
  - GZIP
  - ESCAPE
  - BLANKSASNULL
  - EMPTYASNULL
  - REMOVEQUOTES
delimiter: ,
first_row: 1
file_types:
  theorchardmusic:
    schema:
      - video_id
      - custom_id
      - isrc
      - grid
      - download_date
      - country
      - content_type
      - content_policy
      - owned_views
      - owned_views_watch_page
      - owned_views_embedded_player
      - owned_views_channel_page
      - owned_views_live
      - owned_views_on_demand
      - owned_views_ad_enabled
    validation:
      - "Video ID"
      - "Custom ID"
      - "ISRC"
      - "GRid"
      - "Day"
      - "Country"
      - "Content Type"
      - "Policy"
      - "Owned Views"
      - "Owned Views : Watch Page"
      - "Owned Views : Embedded Player"
      - "Owned Views : Channel Page"
      - "Owned Views : Live"
      - "Owned Views : On Demand"
      - "Owned Views : Ad-Enabled"
  IODA:
    schema:
      - video_id
      - custom_id
      - isrc
      - grid
      - download_date
      - country
      - content_type
      - content_policy
      - owned_views
      - owned_views_watch_page
      - owned_views_embedded_player
      - owned_views_channel_page
      - owned_views_live
      - owned_views_on_demand
      - owned_views_ad_enabled
    validation:
      - "Video ID"
      - "Custom ID"
      - "ISRC"
      - "GRid"
      - "Day"
      - "Country"
      - "Content Type"
      - "Policy"
      - "Owned Views"
      - "Owned Views : Watch Page"
      - "Owned Views : Embedded Player"
      - "Owned Views : Channel Page"
      - "Owned Views : Live"
      - "Owned Views : On Demand"
      - "Owned Views : Ad-Enabled"
  default:
    schema:
      - video_id
      - custom_id
      - isrc
      - grid
      - download_date
      - country
      - content_type
      - content_policy
      - owned_views
      - owned_views_watch_page
      - owned_views_embedded_player
      - owned_views_channel_page
      - owned_views_live
      - owned_views_on_demand
      - owned_views_ad_enabled
    validation:
      - "Video ID"
      - "Custom ID"
      - "ISRC"
      - "GRid"
      - "Day"
      - "Country"
      - "Content Type"
      - "Policy"
      - "Owned Views"
      - "Owned Views : Watch Page"
      - "Owned Views : Embedded Player"
      - "Owned Views : Channel Page"
      - "Owned Views : Live"
      - "Owned Views : On Demand"
      - "Owned Views : Ad-Enabled"
raw_table_schema:
  - ingestion_time
  - filename
  - filesize
  - video_id
  - custom_id
  - isrc
  - grid
  - download_date
  - country
  - content_type
  - content_policy
  - owned_views_embedded_player
  - owned_views_watch_page
  - upc
  - original_upc
  - owned_views
  - owned_views_channel_page
  - owned_views_live
  - owned_views_on_demand
  - owned_views_ad_enabled
  - artist
  - asset_title
mapping:
  - do_nothing