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
      - total_views
      - watch_views
      - embed_views
      - channel_page_video_views
      - live_views
      - recorded_views
      - ad_enabled_views
    validation:
      - "Video ID"
      - "Custom ID"
      - "ISRC"
      - "GRid"
      - "Day"
      - "Country"
      - "Content Type"
      - "Policy"
      - "Total Views"
      - "Watch Page Views"
      - "Embedded Player Views"
      - "Channel Page Video Views"
      - "Live Views"
      - "Recorded Views"
      - "Ad-Enabled Views"
  IODA:
    schema:
      - video_id
      - custom_id
      - isrc
      - grid
      - download_date
      - country
      - content_type
      - content_policy
      - total_views
      - watch_views
      - embed_views
      - channel_page_video_views
      - live_views
      - recorded_views
      - ad_enabled_views
      - artist
      - asset_title
    validation:
      - "Video ID"
      - "Custom ID"
      - "ISRC"
      - "GRid"
      - "Day"
      - "Country"
      - "Content Type"
      - "Policy"
      - "Total Views"
      - "Watch Page Views"
      - "Embedded Player Views"
      - "Channel Page Video Views"
      - "Live Views"
      - "Recorded Views"
      - "Ad-Enabled Views"
      - "Artist"
      - "Asset Title"
  default:
    schema:
      - video_id
      - custom_id
      - isrc
      - grid
      - download_date
      - country
      - content_type
      - content_policy
      - total_views
      - watch_views
      - embed_views
      - channel_page_video_views
      - live_views
      - recorded_views
      - ad_enabled_views
      - artist
      - asset_title
    validation:
      - "Video ID"
      - "Custom ID"
      - "ISRC"
      - "GRid"
      - "Day"
      - "Country"
      - "Content Type"
      - "Policy"
      - "Total Views"
      - "Watch Page Views"
      - "Embedded Player Views"
      - "Channel Page Video Views"
      - "Live Views"
      - "Recorded Views"
      - "Ad-Enabled Views"
      - "Artist"
      - "Asset Title"
raw_table_schema:
  - ingestion_time
  - filename
  - filesize
  - video_id
  - custom_id
  - isrc
  - grid
  - download_date
  - country
  - content_type
  - content_policy
  - embed_views
  - watch_views
  - upc
  - original_upc
  - total_views
  - channel_page_video_views
  - live_views
  - recorded_views
  - ad_enabled_views
  - ad_requested_views
  - artist
  - asset_title
mapping:
  - do_nothing