local:
  temp_folder: /mnt/data/tmp/exportAnalyticsRawFilesDirectory/GooglePlay
  import_folder: /mnt/data/tmp/importAnalyticsRawFilesDirectory/GooglePlay
sftp:
  host: ftp.theorchard.com
  username: REPLACEME
  password: REPLACEME
  folder: GooglePlay_daily
s3:
  bucket: cucumbers
  archives_folder: GooglePlayV2/archives
  import_folder: GooglePlayV2/to_be_imported_into_redshift
expected_number_of_files: 4
check_num_of_files: true
store_id: 49602
raw_table_name: staging_raw_googleplay
import_options:
  - GZIP
  - CSV
  - IGNOREBLANKLINES
  - IGNOREHEADER AS 1
  - DATEFORMAT AS 'YYYY-MM-DD'
csv_file:
    delimiter: ,
    first_row: 5
    header:
      - Per Transaction Report
      - "Reporting Period:" # colon at end breaks the array
      - "Native Retail Currency:"
      - "Native Partner Currency:"
    schema:
      - Country
      - Transaction Date
      - Name of Title
      - Season Title
      - Show Title
      - Channel Name
      - Video Category
      - YouTube Video ID
      - Partner Reporting ID
      - Transaction Type
      - Resolution
      - Refund/Chargeback
      - Coupon Used
      - Purchase Location
      - Retail Price (USD)
      - Native Retail Price
      - Tax Exclusive Retail Price (USD)
      - Native Tax Exclusive Retail Price
      - Total Tax (USD)
      - Native Total Tax
      - Partner Earnings Fraction
      - Contractual Minimum Partner Earnings (USD)
      - Native Contractual Minimum Partner Earnings
      - Partner Earnings Using Tax Exclusive Retail Price (USD)
      - Native Partner Earnings Using Tax Exclusive Retail Price
      - Final Partner Earnings (USD)
      - Native Final Partner Earnings
      - Conversion Rate
    footer:
      - "EST Totals:"
      - "VOD Totals:"
      - "Totals:"
raw_table_schema:
  ingestion_time: ingestion_time
  download_date: download_date
  filename: filename
  filesize: filesize
  reporting_period: "Reporting Period:"
  native_retail_currency: "Native Retail Currency:"
  native_partner_currency: "Native Partner Currency:"
  country: Country
  transaction_date: Transaction Date
  name_of_title: Name of Title
  season_title: Season Title
  show_title: Show Title
  channel_name: Channel Name
  video_category: Video Category
  youtube_video_id: YouTube Video ID
  partner_reporting_id: Partner Reporting ID
  transaction_type: Transaction Type
  resolution: Resolution
  refund_chargeback: Refund/Chargeback
  coupon_used: Coupon Used
  purchase_location: Purchase Location
  retail_price_usd: Retail Price (USD)
  native_retail_price: Native Retail Price
  tax_exclusive_retail_price_usd: Tax Exclusive Retail Price (USD)
  native_tax_exclusive_retail_price: Native Tax Exclusive Retail Price
  total_tax_usd: Total Tax (USD)
  native_total_tax: Native Total Tax
  partner_earnings_fraction: Partner Earnings Fraction
  contractual_minimum_partner_earnings_usd: Contractual Minimum Partner Earnings (USD)
  native_contractual_minimum_partner_earnings: Native Contractual Minimum Partner Earnings
  partner_earnings_using_tax_exclusive_retail_price_usd: Partner Earnings Using Tax Exclusive Retail Price (USD)
  native_partner_earnings_using_tax_exclusive_retail_price: Native Partner Earnings Using Tax Exclusive Retail Price
  final_partner_earnings_usd: Final Partner Earnings (USD)
  native_final_partner_earnings: Native Final Partner Earnings
  conversion_rate: Conversion Rate
fix_native_currency:
      - native_retail_price
      - native_tax_exclusive_retail_price
      - native_contractual_minimum_partner_earnings
      - native_partner_earnings_using_tax_exclusive_retail_price
      - native_final_partner_earnings
mapping:
  -