---
title: Snowflake - Artifacts
description: The artifacts of a Snowflake generator are SnowSQL scripts plus a PowerShell script that deploys them.
---

[Skip to content](https://knowledge.bigenius-x.com/snowflake-artifacts-2.0#main-content)

[Contact us](https://knowledge.bigenius-x.com/kb-tickets/new?hsLang=en) [Go to Customer Portal](https://knowledge.bigenius-x.com/customer-portal?hsLang=en)

[![TRI\_Logo\_biGENIUS\_2020\_RGB\_s](https://knowledge.bigenius-x.com/hs-fs/hubfs/Marketing/TRI_Logo_biGENIUS_2020_RGB_s.png?width=150&height=42&name=TRI_Logo_biGENIUS_2020_RGB_s.png)](https://www.bigenius-x.com/)

Open main navigation

Close main navigation

- [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new)
- [Go to Customer Portal](https://knowledge.bigenius-x.com/customer-portal)

 How can we help you?

- There are no suggestions because the search field is empty.

1. [biGENIUS-X Knowledge Base](https://knowledge.bigenius-x.com/?hsLang=en)
2. [Generators](https://knowledge.bigenius-x.com/generators?hsLang=en)
3. [Artifacts](https://knowledge.bigenius-x.com/generators?hsLang=en#artifacts)

# Snowflake - Artifacts

**Applies to**  
Platform: Snowflake

The artifacts of a Snowflake generator are SnowSQL scripts plus a PowerShell script that deploys them. This article explains what each file does and how the files call each other. Use it to find the script that failed and to see which project settings change the artifacts.

All eight Snowflake generator configurations produce this structure. The layer scripts differ per configuration.

### Files in the artifacts folder

The download is a zip file. Unpacked, the artifacts folder of a DataVault and Mart project contains:

![Generated artifacts root folder with the LoadControl and SQL folders, deploy.ps1, deploy.sql, README.md, replace\_placeholders.ps1 and replacement\_config.json](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Mar-23-2026-08-52-02-6662-AM.png?width=516&height=301&name=image-png-Mar-23-2026-08-52-02-6662-AM.png)

- `deploy.ps1`: checks that SnowSQL is installed, asks for the SnowSQL connection and runs `deploy.sql` with SnowSQL. See [Snowflake - Deployment](https://knowledge.bigenius-x.com/snowflake-deployment-2.0?hsLang=en).
- `deploy.sql`: runs `SQL\deploy_prerequisites.sql` when the artifacts contain it, then `SQL\deploy_all_layers.sql` and `LoadControl\configure_loadcontrol.sql`.
- `replace_placeholders.ps1` and `replacement_config.json`: replace the placeholders of all files. See [Replace the placeholders in the artifacts](https://knowledge.bigenius-x.com/replace-the-placeholders-in-the-artifacts?hsLang=en) and [Snowflake - Placeholder values](https://knowledge.bigenius-x.com/snowflake-placeholder-values-2.0?hsLang=en).
- `README.md`: the generator and its version, the project, the branch and the build time.
- `SQL\`: `deploy_all_layers.sql` and one script per layer numbered in load order, for example `L010_Stage.sql` and `L020_Raw Vault.sql`.  
  ![SQL folder with deploy\_all\_layers.sql and one script per layer from L010\_Stage.sql to L040\_Mart.sql](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Apr-01-2025-08-04-24-3379-AM.png?width=517&height=231&name=image-png-Apr-01-2025-08-04-24-3379-AM.png)
- `LoadControl\`: the task scripts, the helper scripts or the Airflow DAG, depending on the project settings below.
- `ParseError.log`: only when the generation reported validation warnings; it lists them.

### What the deployment scripts create

Each layer script switches to the database of its layer and creates the schema when it is missing. The databases must exist. Then it creates the objects of each model object:

- Tables: with the default [Deployment Options](https://knowledge.bigenius-x.com/deployment-options-project?hsLang=en), each table is replaced by an empty one (`CREATE OR REPLACE`). Stage tables are transient. With `Generate Drop Table Statements` cleared, only missing tables are created (`CREATE TABLE IF NOT EXISTS`).
- Views: replaced, for example `<object>_SOURCE` and `<object>_RESULT`.
- Stored procedures: the loaders `<object>_LOADER`, replaced.
- Streams: for each dataflow with [Use Stream](https://knowledge.bigenius-x.com/use-stream-model-object?hsLang=en), a view `<object>_SOURCE_STREAMSOURCE` and a stream `<object>_SOURCE` on it.

The task script of the load control suspends the scheduled root tasks of the load control schema. It stops with error -20001 when a task graph of that schema is still running or scheduled. With the default Deployment Options it then drops the load control schema with all objects in it and creates it again. With `Generate Drop Load Control Schema` cleared, the schema is kept and the tasks are replaced.

### Settings that change the artifacts

- [LoadControl Options (Project)](https://knowledge.bigenius-x.com/loadcontrol-options-project?hsLang=en): each option adds its files to the folder `LoadControl`: 
    - Depending Tasks: `snowflake_depending_tasks.sql` and `snowflake_depending_tasks_helper.sql`.
    - Stage-Driven Tasks: `snowflake_stage_driven_tasks.sql`, `snowflake_stage_driven_tasks_set_loglevel.sql` and `snowflake_stage_driven_tasks_helper.sql`.
    - Near-Realtime Tasks: `snowflake_tasks_streams.sql`.
    - Airflow: the DAG `<project>_dag.py`, where `<project>` is the project name in lower case with underscores.  
      ![LoadControl folder for Airflow with configure\_loadcontrol.sql and the project DAG Python file](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Oct-13-2025-07-29-45-5670-AM.png?width=640&height=158&name=image-png-Oct-13-2025-07-29-45-5670-AM.png)
  `configure_loadcontrol.sql` runs the task scripts of the one native option that is selected. With Airflow alone, it holds only the comment `-- No deployment script generated for Airflow.` With more than one of the three native options, it holds only a comment, and you run the task script of your choice yourself.
- [Configure LoadControl (Project)](https://knowledge.bigenius-x.com/configure-loadcontrol-project?hsLang=en): with `false`, the artifacts contain no folder `LoadControl`, and `deploy.sql` runs only the layer scripts.
- [Apply Sensitivity Level Tags (Project)](https://knowledge.bigenius-x.com/apply-sensitivity-level-tags-project?hsLang=en): `true` adds `SQL\deploy_prerequisites.sql`. It creates the governance schema and the tag `SENSITIVITY_LEVEL` when they are missing.
- [Deployment Options (Project)](https://knowledge.bigenius-x.com/deployment-options-project?hsLang=en): decides whether existing tables are replaced and whether the load control schema is dropped.

### Example

A DataVault and Mart project with the default Depending Tasks produces these files:

```
deploy.ps1
deploy.sql
README.md
replace_placeholders.ps1
replacement_config.json
LoadControl\configure_loadcontrol.sql
LoadControl\snowflake_depending_tasks.sql
LoadControl\snowflake_depending_tasks_helper.sql
SQL\deploy_all_layers.sql
SQL\L010_Stage.sql
SQL\L020_Raw Vault.sql
SQL\L030_Business Vault.sql
SQL\L040_Mart.sql
```

Its `deploy.sql` reads:

```
!source SQL/deploy_all_layers.sql
!source LoadControl/configure_loadcontrol.sql
```

A Stage table in `L010_Stage.sql` starts with the placeholders of its database and schema:

```
CREATE OR REPLACE TRANSIENT TABLE
  {<project>#stage#database_name}.{<project>#stage#schema_name}
  .STG_ST_BDC_CUSTOMER (
     BG_LOADTIMESTAMP TIMESTAMP_TZ NOT NULL
    ,BG_SOURCESYSTEM VARCHAR NULL
    ,BDC_SHOP_ID VARCHAR NOT NULL
    ,BDC_CUSTOMER_ID VARCHAR NOT NULL
...
```

### Related articles

- Previous: [Generate artifacts](https://knowledge.bigenius-x.com/generate-artifacts?hsLang=en), [Download generated artifacts](https://knowledge.bigenius-x.com/download-generated-artifacts?hsLang=en)
- Next: [Replace the placeholders in the artifacts](https://knowledge.bigenius-x.com/replace-the-placeholders-in-the-artifacts?hsLang=en)
- Reference: [Snowflake - Placeholder values](https://knowledge.bigenius-x.com/snowflake-placeholder-values-2.0?hsLang=en), [LoadControl Options (Project)](https://knowledge.bigenius-x.com/loadcontrol-options-project?hsLang=en), [Configure LoadControl (Project)](https://knowledge.bigenius-x.com/configure-loadcontrol-project?hsLang=en), [Deployment Options (Project)](https://knowledge.bigenius-x.com/deployment-options-project?hsLang=en), [Apply Sensitivity Level Tags (Project)](https://knowledge.bigenius-x.com/apply-sensitivity-level-tags-project?hsLang=en)
- See also: [Snowflake - Deployment](https://knowledge.bigenius-x.com/snowflake-deployment-2.0?hsLang=en), [Snowflake - Load data - Native Load Control](https://knowledge.bigenius-x.com/snowflake-load-data-native-load-control-2.0?hsLang=en), [Snowflake - Load data - Apache Airflow Load Control](https://knowledge.bigenius-x.com/snowflake-load-data-apache-airflow-load-control-2.0?hsLang=en), [Troubleshoot generation, deployment and load failures](https://knowledge.bigenius-x.com/troubleshoot-generation-deployment-and-load-failures?hsLang=en)

- [Getting started](https://knowledge.bigenius-x.com/getting-started?hsLang=en#main-content)

    - [Guidelines](https://knowledge.bigenius-x.com/getting-started?hsLang=en#guidelines)
    - [Start working](https://knowledge.bigenius-x.com/getting-started?hsLang=en#start-working)
    - [Account](https://knowledge.bigenius-x.com/getting-started?hsLang=en#account)
- [General overview](https://knowledge.bigenius-x.com/general-overview?hsLang=en)
- [Artificial Intelligence](https://knowledge.bigenius-x.com/artificial-intelligence?hsLang=en)
- [Application Modules](https://knowledge.bigenius-x.com/application-modules?hsLang=en#main-content)

    - [Administration](https://knowledge.bigenius-x.com/application-modules?hsLang=en#administration)
    - [Solutions](https://knowledge.bigenius-x.com/application-modules?hsLang=en#solutions)
    - [Global Features](https://knowledge.bigenius-x.com/application-modules?hsLang=en#global-features)
    - [Projects](https://knowledge.bigenius-x.com/application-modules?hsLang=en#projects)
    - [Branches](https://knowledge.bigenius-x.com/application-modules?hsLang=en#branches)
    - [Data Connections](https://knowledge.bigenius-x.com/application-modules?hsLang=en#data-connections)
    - [Dataflow Modeling - Overview](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-overview)
    - [Dataflow Modeling - Wizard Steps](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-wizard-steps)
    - [Dataflow Modeling - Terms](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-terms)
    - [Dataflow Modeling - Term Mapping](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-term-mapping)
    - [Dataflow Modeling - Relationships](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-relationships)
    - [Dataflow Modeling - Data Quality](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-data-quality)
    - [Dataflow Modeling - Indexes](https://knowledge.bigenius-x.com/application-modules?hsLang=en#dataflow-modeling-indexes)
    - [Relationship Modeling](https://knowledge.bigenius-x.com/application-modules?hsLang=en#relationship-modeling)
    - [Generate Artifacts](https://knowledge.bigenius-x.com/application-modules?hsLang=en#generate-artifacts)
    - [Project Settings](https://knowledge.bigenius-x.com/application-modules?hsLang=en#project-settings)
    - [Data Marketplace](https://knowledge.bigenius-x.com/application-modules?hsLang=en#data-marketplace)
- [Generators](https://knowledge.bigenius-x.com/generators?hsLang=en#main-content)

    - [Fabric Warehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-warehouse)
    - [Fabric Lakehouse](https://knowledge.bigenius-x.com/generators?hsLang=en#fabric-lakehouse)
    - [Databricks](https://knowledge.bigenius-x.com/generators?hsLang=en#databricks)
    - [Snowflake](https://knowledge.bigenius-x.com/generators?hsLang=en#snowflake)
    - [Microsoft SQL Server](https://knowledge.bigenius-x.com/generators?hsLang=en#microsoft-sql-server)
    - [Oracle](https://knowledge.bigenius-x.com/generators?hsLang=en#oracle)
    - [Artifacts](https://knowledge.bigenius-x.com/generators?hsLang=en#artifacts)
    - [Replace Placeholders](https://knowledge.bigenius-x.com/generators?hsLang=en#replace-placeholders)
    - [Target solution environment](https://knowledge.bigenius-x.com/generators?hsLang=en#target-solution-environment)
    - [Deployment](https://knowledge.bigenius-x.com/generators?hsLang=en#deployment)
    - [Deployment with an Azuze DevOps pipeline](https://knowledge.bigenius-x.com/generators?hsLang=en#deployment-with-an-azuze-devops-pipeline)
    - [Delta Deployment](https://knowledge.bigenius-x.com/generators?hsLang=en#delta-deployment)
    - [Load control environment](https://knowledge.bigenius-x.com/generators?hsLang=en#load-control-environment)
    - [Load data with a native load control](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-a-native-load-control)
    - [Load data with Apache Airflow](https://knowledge.bigenius-x.com/generators?hsLang=en#load-data-with-apache-airflow)
    - [Model Object Type](https://knowledge.bigenius-x.com/generators?hsLang=en#model-object-type)
    - [Properties](https://knowledge.bigenius-x.com/generators?hsLang=en#properties)
    - [Default Terms](https://knowledge.bigenius-x.com/generators?hsLang=en#default-terms)
- [Discovery application](https://knowledge.bigenius-x.com/discovery-application?hsLang=en#main-content)

    - [Discovery configurations](https://knowledge.bigenius-x.com/discovery-application?hsLang=en#discovery-configurations)
- [Best practices](https://knowledge.bigenius-x.com/best-practices?hsLang=en#main-content)

    - [Modeling Approaches](https://knowledge.bigenius-x.com/best-practices?hsLang=en#modeling-approaches)
    - [Use Cases](https://knowledge.bigenius-x.com/best-practices?hsLang=en#use-cases)
    - [Business Rules](https://knowledge.bigenius-x.com/best-practices?hsLang=en#business-rules)
    - [Data Quality Rules](https://knowledge.bigenius-x.com/best-practices?hsLang=en#data-quality-rules)
- [FAQs](https://knowledge.bigenius-x.com/faqs?hsLang=en)
- [Product Release Notes](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#main-content)

    - [SaaS Application](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#saas-application)
    - [Discovery application](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#discovery-application)
    - [Generators](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#generators)
- [Legal Documents](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#main-content)

    - [Current legal docs](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#current-legal-docs)
    - [Software Product and Limits](https://knowledge.bigenius-x.com/legal-documents?hsLang=en#software-product-and-limits)

- [Contact us](https://knowledge.bigenius-x.com/kb-tickets/new?hsLang=en)
- [Customer Portal](https://knowledge.bigenius-x.com/customer-portal)
- [Sign in](https://knowledge.bigenius-x.com/_hcms/mem/login)

[![biGENIUS logo](https://knowledge.bigenius-x.com/hubfs/TRI_Logo_biGENIUS_2020_RGB-1.svg "biGENIUS logo")](https://www.bigenius-x.com)

<https://www.linkedin.com/company/bigenius> <https://www.youtube.com/@biGENIUS_DWA>

All rights reserved © 2025, biGENIUS AG