local:
  temp_folder: /mnt/data/tmp/exportAnalyticsRawFilesDirectory/Youtube_claims
  import_folder: /mnt/data/tmp/importAnalyticsRawFilesDirectory/Youtube_claims
s3:
  bucket: cucumbers
  archives_folder: Youtube_claims/archives
  import_folder: Youtube_claims/to_be_imported_into_redshift
expected_number_of_files: 5
check_num_of_files: true
store_id: 45302
raw_table_name: staging_raw_youtube_claim
import_options:
  - GZIP
  - ESCAPE
  - BLANKSASNULL
  - EMPTYASNULL
  - REMOVEQUOTES
sftp:
  host: ftp.theorchard.com
  username: REPLACEME
  password: REPLACEME
  folder: Youtube_claims
file_types:
  theorchardmusic:
    delimiter: ,
    first_row: 1
    schema:
      - video_id
      - claim_id
      - asset_id
      - video_uploader
      - channel_id
      - channel_display_name
      - video_title
      - video_views
      - status
      - claim_origin
      - claim_type
      - is_partner_uploaded
      - is_premium
      - reference_video_id
      - applied_policy
      - claim_date
      - video_upload_date
      - custom_id
      - isrc
      - grid
      - artist
      - title
      - album
      - label
      - display_upc
      - notes
      - release_date
      - asset_labels
  IODA:
    delimiter: ,
    first_row: 1
    schema:
      - video_id
      - claim_id
      - asset_id
      - video_uploader
      - channel_id
      - channel_display_name
      - video_title
      - video_views
      - status
      - claim_origin
      - claim_type
      - is_partner_uploaded
      - is_premium
      - reference_video_id
      - applied_policy
      - claim_date
      - video_upload_date
      - custom_id
      - isrc
      - grid
      - artist
      - title
      - album
      - label
      - display_upc
      - notes
      - release_date
      - asset_labels
  dmgi:
    delimiter: ,
    first_row: 1
    schema:
      - video_id
      - claim_id
      - asset_id
      - video_uploader
      - channel_id
      - channel_display_name
      - video_title
      - video_views
      - status
      - claim_origin
      - claim_type
      - is_partner_uploaded
      - is_premium
      - reference_video_id
      - applied_policy
      - claim_date
      - video_upload_date
      - custom_id
      - title
      - notes
      - asset_labels
  theorchardpublishing:
    delimiter: ,
    first_frow: 1
    schema:
      - video_id
      - claim_id
      - asset_id
      - video_uploader
      - channel_id
      - channel_display_name
      - video_title
      - video_views
      - status
      - claim_origin
      - claim_type
      - is_partner_uploaded
      - is_premium
      - reference_video_id
      - applied_policy
      - claim_date
      - video_upload_date
      - custom_id
      - iswc
      - title
      - writers
      - notes
      - asset_labels
  BFMDigital:
    delimiter: ,
    first_row: 1
    schema:
      - video_id
      - claim_id
      - asset_id
      - video_uploader
      - channel_id
      - channel_display_name
      - video_title
      - video_views
      - status
      - claim_origin
      - claim_type
      - is_partner_uploaded
      - is_premium
      - reference_video_id
      - applied_policy
      - claim_date
      - video_upload_date
      - custom_id
      - isrc
      - grid
      - artist
      - title
      - album
      - label
      - display_upc
      - notes
      - release_date
      - asset_labels
raw_table_schema:
  - video_id
  - claim_id
  - asset_id
  - video_uploader
  - video_title
  - video_views
  - status
  - claim_origin
  - claim_type
  - is_partner_uploaded
  - is_premium
  - reference_video_id
  - applied_policy
  - claim_date
  - video_upload_date
  - custom_id
  - isrc
  - grid
  - artist
  - video_title
  - album
  - label
  - upc
  - display_upc
  - notes
  - release_date
  - iswc
  - writers
  - is_in_video_report
  - is_art_track
  - asset_labels
  - channel_id
  - channel_display_name
#TODO (jchung): Validation on data type per raw_table_schema
mapping:
  - do_nothing