This is the second version of the entire Batch Handling process involving VSLR and LD.
The process steps are:
- Run Query
- Save Query to Excel File
- Upload File to ShareFile
Prerequisite steps to run the program include the following:
- Add the query file-paths to variables found in "Batches.py"
- Add the ShareFile App directory you want the file saved to a variable found in "Batches.py".
- Make a JSON formatted Environment Variable, named "SNOWFLAKE_KEY" that includes these fields:
- USERNAME
- PASSWORD
- ACCOUNT
- WAREHOUSE
- DATABASE
Please see the official Snowflake Documentation for definitions of the required fields.