#ETL_SQL
This repository contains the SQL used by the Data Analytics Department for various ETLs<br>

The folders are organized by category:<br>

**Accounting** <br>
Files 1-5 in this folder should be run *manually*, *consecutively*, and *monthly*.

This folder contains a file marked FULL; this files should be excluded and exist as backup.<br>


**Analytics** <br>
Files 1-5 and 1a-5a can be run *consecutively* from 1 to 5 and 1a to 5a and *concurrently* of each other.<br>

These files should be run *automatically* and *daily at 8am* via the *Looker_Warehouse_X_Small Medium*.<br>

This folder contains a file marked FULL; this files should be excluded and exist as backup.<br>


**Apple**<br>
Files 1-5 can be run *consecutively*. <br>

These files should be run *automatically* and *daily at 8am* via the *Looker_Warehouse_X_Small Medium*.<br>

This folder contains a file marked FULL; this files should be excluded and exist as backup.<br>


**Spotify**
Files 1-6 can be run *consecutively*. <br>

These files should be run *automatically* and *daily at 8am* via the *Looker_Warehouse_X_Small Medium*.<br>

This folder contains a file marked FULL; this files should be excluded and exist as backup.<br>