Deployment
      Back to home
      1. biGENIUS-X Help Center
      2. Generators
      3. Deployment

      Snowflake - Deployment - 1.4

      Before deploying the Generated Artifacts, please:

      You should now have the SQL scripts ready for deployment.

      Deploy the generated Artifacts

      We will explain deploying the generated artifacts using the possible target environment for Snowflake.

      To deploy the generated Artifacts:

      • Open Snowflake
      • Execute the Worksheets for each Layer. In our example, they are:
        • L010_Stage
        • L020_Raw Vault
        • L030_Business Vault
        • L040_Mart

      To execute all the lines of a Worksheet, select all the lines, then click on the Play button:

      • Execute the Load Control creation Worksheet. In our example, it is Snowflake1_4_0DataVaultandMart_tasks
      • You should now have the Target system created with the structure of future data, for example, in the SA schema:
        Tables Views Stored Procedures

         

         

         

         
        • You should also now have the structure of the Load Control composed of Snowflake Tasks in the LC schema:


        You can now load the data.