# Instagram Reels and Facebook shorts

The data source is tables shared by SME by AWS lakeformation.
This flow runs SQL query in Athena and saves the result to snowflake table.

* Source Athena database: `facebook_main_db`

# Reports

| report name | staging raw table                  | periodic |
|-------------|------------------------------------|----------|
| Veiws       | staging_raw_insta_shorts_views     | monthly  |
| Creations   | staging_raw_insta_shorts_creations | monthly  |


# Data availability

The data usually becomes available with significant delay (more than 2 months).

| report    | report_date | become available at |
|-----------|-------------|---------------------| 
| views     | 2024-01-01  | 2024-03-05          |
| creations | 2024-01-01  | 2024-03-05          |