local:
  temp_folder: /mnt/data/tmp/exportAnalyticsRawFilesDirectory/Google
  import_folder: /mnt/data/tmp/importAnalyticsRawFilesDirectory/Google
s3:
  bucket: cucumbers
  archives_folder: Google/archives
  import_folder: Google/to_be_imported_into_redshift
expected_number_of_files: 191
check_num_of_files: true
store_id: 496
raw_table_name: staging_raw_google
import_options:
  - escape
  - gzip
sftp:
  host: ftp.theorchard.com
  username: REPLACEME
  password: REPLACEME
file_types:
  GOOGLE_ORCHARD_TRANS:
    delimiter: ,
    first_row: 4
    schema:
      - Start_Date
      - End_Date
      - UPC
      - GRID
      - ISRC
      - Custom_ID_1
      - Custom_ID_2
      - Custom_ID_3
      - Custom_ID_4
      - Google_ID
      - Artist
      - Product_Title
      - Container_Title
      - Content_Provider
      - Label
      - Consumer_Country
      - Device_Type
      - Product_Type
      - Interaction_Type
      - Count
      - Consumer_Zip_Code
      - Retail_Price
      - Retail_Currency
      - Wholesale_Price
      - Wholesale_Currency
      - Partner_Revenue_Paid
      - Partner_Revenue_Currency
      - Partner_Revenue_Invoiced
      - Partner_Revenue_Invoiced_Currency
  GOOGLE_ORCHARD_SUBSCRIPTION_MKT:
    delimiter: ,
    first_row: 4
    schema:
      - Start_Date
      - End_Date
      - UPC
      - GRID
      - ISRC
      - Custom_ID_1
      - Custom_ID_2
      - Custom_ID_3
      - Custom_ID_4
      - Google_ID
      - Artist
      - Product_Title
      - Container_Title
      - Content_Provider
      - Label
      - Consumer_Country
      - Device_Type
      - Product_Type
      - Interaction_Type
      - Count
  GOOGLE_ORCHARD_PREORDER:
    delimiter: ,
    first_row: 4
    schema:
      - Start_Date
      - End_Date
      - UPC
      - GRID
      - ISRC
      - Custom_ID_1
      - Custom_ID_2
      - Custom_ID_3
      - Custom_ID_4
      - Google_ID
      - Artist
      - Product_Title
      - Container_Title
      - Content_Provider
      - Label
      - Consumer_Country
      - Device_Type
      - Product_Type
      - Interaction_Type
      - Count
      - Consumer_Zip_Code
      - Retail_Price
      - Retail_Currency
      - Wholesale_Price
      - Wholesale_Currency
      - Partner_Revenue_Paid
      - Partner_Revenue_Currency
      - Partner_Revenue_Invoiced
      - Partner_Revenue_Invoiced_Currency
raw_table_schema:
  - start_date
  - end_date
  - upc
  - grid
  - isrc
  - customer_id_1
  - customer_id_2
  - customer_id_3
  - customer_id_4
  - google_id
  - artist
  - product_title
  - container_title
  - content_provider
  - label
  - consumer_country
  - device_type
  - product_type
  - interaction_type
  - cnt
  - consumer_zip_code
  - retail_price
  - retail_currency
  - wholesale_price
  - wholesale_currency
  - partner_revenue_paid
  - partner_revenue_currency
  - partner_revenue_invoiced
  - partner_revenue_invoiced_currency
#todo: validation on data type will be in the above schema