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: 4
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:
      - claim_id
      - claim_status
      - claim_status_detail
      - claim_origin
      - claim_type
      - asset_id
      - video_id
      - uploader
      - channel_id
      - channel_display_name
      - video_title
      - views
      - matching_duration
      - longest_match
      - content_type
      - reference_video_id
      - reference_id
      - claim_policy_id
      - asset_policy_id
      - claim_policy_monetize
      - claim_policy_track
      - claim_policy_block
      - asset_policy_monetize
      - asset_policy_track
      - asset_policy_block
      - claim_created_date
      - video_upload_date
      - custom_id
      - video_duration_sec
      - asset_title
      - asset_labels
      - tms
      - director
      - studio
      - season
      - episode_number
      - episode_title
      - release_date
      - hfa_song_code
      - isrc
      - grid
      - artist
      - album
      - record_label
      - display_upc
      - iswc
      - writers
  IODA:
    delimiter: ,
    first_row: 1
    schema:
      - claim_id
      - claim_status
      - claim_status_detail
      - claim_origin
      - claim_type
      - asset_id
      - video_id
      - uploader
      - channel_id
      - channel_display_name
      - video_title
      - views
      - matching_duration
      - longest_match
      - content_type
      - reference_video_id
      - reference_id
      - claim_policy_id
      - asset_policy_id
      - claim_policy_monetize
      - claim_policy_track
      - claim_policy_block
      - asset_policy_monetize
      - asset_policy_track
      - asset_policy_block
      - claim_created_date
      - video_upload_date
      - custom_id
      - video_duration_sec
      - asset_title
      - asset_labels
      - tms
      - director
      - studio
      - season
      - episode_number
      - episode_title
      - release_date
      - hfa_song_code
      - isrc
      - grid
      - artist
      - album
      - record_label
      - display_upc
      - iswc
      - writers
  dmgi:
    delimiter: ,
    first_row: 1
    schema:
      - claim_id
      - claim_status
      - claim_status_detail
      - claim_origin
      - claim_type
      - asset_id
      - video_id
      - uploader
      - channel_id
      - channel_display_name
      - video_title
      - views
      - matching_duration
      - longest_match
      - content_type
      - reference_video_id
      - reference_id
      - claim_policy_id
      - asset_policy_id
      - claim_policy_monetize
      - claim_policy_track
      - claim_policy_block
      - asset_policy_monetize
      - asset_policy_track
      - asset_policy_block
      - claim_created_date
      - video_upload_date
      - custom_id
      - video_duration_sec
      - asset_title
      - asset_labels
      - tms
      - director
      - studio
      - season
      - episode_number
      - episode_title
      - release_date
      - hfa_song_code
      - isrc
      - grid
      - artist
      - album
      - record_label
      - display_upc
      - iswc
      - writers
  BFMDigital:
    delimiter: ,
    first_row: 1
    schema:
      - claim_id
      - claim_status
      - claim_status_detail
      - claim_origin
      - claim_type
      - asset_id
      - video_id
      - uploader
      - channel_id
      - channel_display_name
      - video_title
      - views
      - matching_duration
      - longest_match
      - content_type
      - reference_video_id
      - reference_id
      - claim_policy_id
      - asset_policy_id
      - claim_policy_monetize
      - claim_policy_track
      - claim_policy_block
      - asset_policy_monetize
      - asset_policy_track
      - asset_policy_block
      - claim_created_date
      - video_upload_date
      - custom_id
      - video_duration_sec
      - asset_title
      - asset_labels
      - tms
      - director
      - studio
      - season
      - episode_number
      - episode_title
      - release_date
      - hfa_song_code
      - isrc
      - grid
      - artist
      - album
      - record_label
      - display_upc
      - iswc
      - writers
raw_table_schema:
  - video_id
  - claim_id
  - asset_id
  - uploader
  - video_title
  - views
  - claim_status
  - claim_origin
  - claim_type
  - is_partner_uploaded
  - is_premium
  - reference_video_id
  - applied_policy
  - claim_created_date
  - video_upload_date
  - custom_id
  - isrc
  - grid
  - artist
  - asset_title
  - album
  - record_label
  - upc
  - display_upc
  - notes
  - release_date
  - iswc
  - writers
  - is_in_video_report
  - is_art_track
  - asset_labels
  - channel_id
  - channel_display_name
  - claim_status_detail
  - matching_duration
  - longest_match
  - content_type
  - reference_id
  - claim_policy_id
  - asset_policy_id
  - claim_policy_monetize
  - claim_policy_track
  - claim_policy_block
  - asset_policy_monetize
  - asset_policy_track
  - asset_policy_block
  - video_duration_sec
  - tms
  - director
  - studio
  - season
  - episode_number
  - episode_title
  - hfa_song_code
#TODO (jchung): Validation on data type per raw_table_schema
mapping:
  - do_nothing