Before deploying the Generated Artifacts, please:
- Generate the Artifacts
- Download the generated Artifacts
- Replace the placeholders in the Generated Artifacts
You should now have the SQL scripts ready for deployment.
Prerequisites
To deploy all the generated artifacts quickly, please install SnowSQL.
You can download it here.
If you prefer not using SnowSQL for the deployment, you can execute manually each of the generated artifacts.
Deploy the generated Artifacts
We will explain deploying the generated artifacts using the possible target environment for Snowflake.
To deploy the generated Artifacts:
- Open Powershell
- Navigate to your generated artifacts folder:
--Example
cd C:\XXXXXXXXX\20240219144515
- Execute the Powershell script helper for deployment:
.\deploy.ps1
- The prompt asks you for your Snowflake account:
- Enter your Snowflake account:
- Enter a user:
- Enter the password:
- You have a similar result:
-------------------------------------------------------------------------------------------------------------------------
The helper script deploy.ps1 will deploy all the scripts from the folders LoadControl and SQL in the correct order.
If you selected several LoadControl Options as:
The Load Control will not be deployed thanks to the deploy.ps1 script as it can't choose for you.
Please deploy the Load Control manually by executing, depending on the LoadControl Options Property values:
- Depending Tasks: the XXXX_tasks.sql script
- Near-realtime Tasks: the XXXXX_tasks_streams.sql script
- Stage-Driven Tasks: the XXXXX_stage_driven_tasks.sql script
- You should now have the Target system created with the structure of future data and the Load Control structure:
| Tables | Views |
|
|
|
|
Procedures |
Tasks |
|
|
|
You can now load the data with the following load controls: