# SME Latam

This feed provider is SME Latam.
The contact person can be found in the [DSP Master List](https://www.notion.so/5991ef3545704cb2a285239cd204f7ab?v=4e42ba5a14be4a70bfc08eec6317a437)

This is a weekly flow.

## Data location

The data is ingested to snowflake table:

* `data.prod.staging_raw_sme_latam_weekly_unified_chart`

## Workflow
* the file is uploaded to SFTP manually by provider. Usually it happens on Tuesday for the past week.
  * Host: sftp://sftp.theorchard.com
  * Username: sme-data-drop
  * Folder: "year" like ("2023/")
  * Filename: "BMAT - Sony - Sony Latam Unified Weekly Chart - Week NN.xlsx"
    Where NN is week number of the year.

* the flow runs by [Jenkins job](https://scheduler.theorchard.io/job/swf-sme-latam-exec/) by schedule 
* The job run every day and look the data for 1 week back
* Ingestion process can be monitored by https://monty.theorchard.io/ (in VPN)