local:
  temp_folder: /mnt/data/tmp/exportAnalyticsRawFilesDirectory/AmazonDigitalServicesInc
  import_folder: /mnt/data/tmp/importAnalyticsRawFilesDirectory/AmazonDigitalServicesInc
s3:
  bucket: cucumbers
  archives_folder: AmazonV2/archives
  import_folder: AmazonV2/to_be_imported_into_redshift
expected_number_of_files: 16
check_num_of_files: true
store_id: 187
raw_table_name: staging_raw_amazon_v2
import_options:
  - escape
  - removequotes
  - gzip
ftp:
  host: digital-music-ftp.amazonmp3.com
  username: replace_me
  password: replace_me
file_types:
  YYYYMMDD_Summary_Statement:
    extension: .csv.zip
    delimiter: ,
    first_row: 1
    format: csv
    schema:
      - vendor_code
      - territory_code
      - start_date
      - end_date
      - upc_from_amazon
      - isrc_from_amazon
      - product_type_id
      - album_asin
      - track_asin
      - album_vendor_product_identifier
      - track_vendor_product_identifier
      - album_name
      - track_name
      - artist_name
      - label_name
      - units
      - cost
      - cost_currency
      - amount
      - sale_return_flag
      - sale_type
  AmazonMP3_JP_Daily_YYYYMMDD:
    extension: .txt.zip
    delimiter: ,
    first_row: 3
    format: csv
    schema:
      - date_of_sale
      - territory_code
      - vendor_product_identifier
      - asin
      - related_upc
      - album_track_flag
      - isrc
      - product_artist
      - product_title
      - label_name
      - cost_currency
      - units
      - cost

countries:
  - AT
  - CH
  - DE
  - ES
  - FR
  - IT
  - JP
  - US
  - GB
raw_table_schema:
  vendor_code: vendor_code
  territory_code: territory_code
  start_date: start_date
  end_date: end_date
  upc_from_amazon: upc
  isrc_from_amazon: isrc
  product_type_id: product_type_id
  album_asin: album_asin
  track_asin: track_asin
  album_vendor_product_identifier: album_vendor_product_identifier
  track_vendor_product_identifier: track_vendor_product_identifier
  album_name: album_name
  track_name: track_name
  artist_name: artist_name
  label_name: label_name
  units: units
  cost: cost
  cost_currency: cost_currency
  amount: amount
  sale_return_flag: sale_return_flag
  sale_type: sale_type
  download_date: download_date
  ingestion_time: ingestion_time
  filename: filename

mapping:
  -