local:
  temp_folder: /mnt/data/tmp/exportAnalyticsRawFilesDirectory/Youtube_video_report
  import_folder: /mnt/data/tmp/importAnalyticsRawFilesDirectory/Youtube_video_report
s3:
  bucket: cucumbers
  archives_folder: Youtube_video_report/archives
  import_folder: Youtube_video_report/to_be_imported_into_redshift
expected_number_of_files: 4
check_num_of_files: true
store_id: 45303
raw_table_name: staging_raw_youtube_video_report
import_options:
  - GZIP
  - ESCAPE
  - BLANKSASNULL
  - EMPTYASNULL
  - REMOVEQUOTES
sftp:
  host: ftp.theorchard.com
  username: REPLACEME
  password: REPLACEME
  folder: Youtube_video_report
file_types:
  - theorchardmusic
  - IODA
  - BFMDigital
  - dmgi
delimter: ,
first_row: 1
schema:
  - video_id
  - username
  - time_uploaded
  - title
  - length
  - view_count
  - comment_count
  - status
  - category
  - favorite_count
  - embedding_allowed
  - ratings_allowed
  - responses_allowed
  - comments_allowed
  - is_licensed
  - offweb_syndicatable
  - in_video_ads_enabled
  - claim_source
  - claimed_by_this_owner
  - claimed_by_another_owner
  - claim_id
  - asset_id
  - claim_custom_id
  - policy
  - third_party_ads_enabled
  - afv_overlay_enabled
  - instream_ads_enabled
  - long_instream_enabled
  - trueview_instream_enabled
  - trueview_inslate_enabled
  - prerolls_enabled
  - midrolls_enabled
  - postrolls_enabled
  - isrc
validation:
  - video_id
  - username
  - time_uploaded
  - title
  - length
  - view_count
  - comment_count
  - status
  - category
  - favorite_count
  - embedding_allowed
  - ratings_allowed
  - responses_allowed
  - comments_allowed
  - is_licensed
  - offweb_syndicatable
  - in_video_ads_enabled
  - claim_source
  - claimed_by_this_owner
  - claimed_by_another_owner
  - claim_id
  - asset_id
  - claim_custom_id
  - policy
  - third_party_ads_enabled
  - afv_overlay_enabled
  - instream_ads_enabled
  - long_instream_enabled
  - trueview_instream_enabled
  - trueview_inslate_enabled
  - prerolls_enabled
  - midrolls_enabled
  - postrolls_enabled
  - isrc
raw_table_schema:
  - video_id
  - username
  - time_uploaded
  - title
  - length
  - view_count
  - comment_count
  - status
  - category
  - favorite_count
  - embedding_allowed
  - ratings_allowed
  - responses_allowed
  - comments_allowed
  - is_licensed
  - offweb_syndicatable
  - in_video_ads_enabled
  - claim_source
  - claimed_by_this_owner
  - claimed_by_another_owner
  - claim_id
  - asset_id
  - claim_custom_id
  - policy
  - third_party_ads_enabled
  - afv_overlay_enabled
  - instream_ads_enabled
  - long_instream_enabled
  - trueview_instream_enabled
  - trueview_inslate_enabled
  - prerolls_enabled
  - midrolls_enabled
  - postrolls_enabled
  - isrc
mapping:
  - do_nothing