local:
  import_folder: /mnt/data/tmp/importAnalyticsRawFilesDirectory/Youtube_asset_report
  temp_folder: /mnt/data/tmp/exportAnalyticsRawFilesDirectory/Youtube_asset_report
s3:
  bucket: cucumbers
  download_folder: Youtube_asset_report/downloads
  archives_folder: Youtube_asset_report/archives
  import_folder: Youtube_asset_report/to_be_imported_into_redshift
expected_number_of_files: 4
check_num_of_files: true
store_id: 45304
raw_table_name: staging_raw_youtube_asset_report
import_options:
  - GZIP
  - ESCAPE
  - BLANKSASNULL
  - EMPTYASNULL
  - REMOVEQUOTES
delimiter: ,
first_row: 1
file_types:
  dmgi:
    schema:      
      - recent_daily_average
      - asset_id
      - asset_type
      - status
      - metadata_origination
      - custom_id
      - season_number
      - episode_title
      - tms
      - number_of_claims
      - constituent_asset_ids
      - active_reference_ids
      - inactive_reference_ids
      - match_policy
      - is_merged_asset
      - conflicting_owner
      - ownership
      - asset_labels
    validation:
      - Recent Daily Average
      - Asset ID
      - Asset Type
      - Status
      - Metadata Origination
      - Custom ID
      - Season Number
      - Episode Title
      - TMS
      - Number of Claims
      - Constituent Asset IDs
      - Active Reference IDs
      - Inactive Reference IDs
      - Match Policy
      - Is Merged Asset(Yes/No)
      - Conflicting Owner
      - Ownership
      - Asset Labels
  default:
    schema:
      - recent_daily_average
      - asset_id
      - asset_type
      - status
      - metadata_origination
      - custom_id
      - isrc
      - grid
      - upc
      - artist
      - song
      - album
      - label
      - constituent_asset_ids
      - active_reference_ids
      - inactive_reference_ids
      - match_policy
      - is_merged_asset
      - ownership
      - conflicting_territories
      - comp_publishing_cleared
      - comp_100_ownership
      - embedded_asset_ids
      - asset_labels
    validation:
      - Recent Daily Average
      - Asset ID
      - Asset Type
      - Status
      - Metadata Origination
      - Custom ID
      - ISRC
      - GRID
      - UPC
      - Artist
      - Song
      - Album
      - Label
      - Constituent Asset IDs
      - Active Reference IDs
      - Inactive Reference IDs
      - Match Policy
      - Is Merged Asset(Yes/No)
      - Ownership
      - Conflicting Territories
      - Comp. Publishing Cleared
      - Comp. 100% Ownership
      - Embedded Asset IDs
      - Asset Labels
raw_table_schema:
- recent_daily_average
- asset_id
- asset_type
- status
- metadata_origination
- custom_id
- isrc
- grid
- upc
- artist
- song
- album
- label
- constituent_asset_ids
- active_reference_ids
- inactive_reference_ids
- match_policy
- is_merged_asset
- ownership
- conflicting_territories
- comp_publishing_cleared
- comp_100_ownership
- embedded_asset_ids
- asset_labels
- season_number
- episode_title
- tms
- number_of_claims
- conflicting_owner
mapping:
  - do_nothing