--- title: Use a biGENIUS-X Generator description: A generator turns your model into artifacts that you deploy and load on your target platform. --- [Skip to content](https://knowledge.bigenius-x.com/use-a-bigenius-x-generator#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) # Use a biGENIUS-X Generator **Applies to** Platform: Microsoft SQL Server · Snowflake · Snowflake dbt · Databricks · Databricks dbt · Fabric Lakehouse · Fabric Warehouse · Oracle A generator turns your model into artifacts that you deploy and load on your target platform. You generate, replace the placeholders, deploy and load, in this order, and repeat the cycle after each model change. This article links the article for each stage and platform, and the explanations and references behind them. ![Cycle of generate the artifacts, download the artifacts, replace the placeholders, deployment and load data](https://knowledge.bigenius-x.com/hs-fs/hubfs/image-png-Feb-27-2025-01-10-27-3946-PM.png?width=688&height=507&name=image-png-Feb-27-2025-01-10-27-3946-PM.png) ### Choose a generator configuration Each project has one generator configuration, which sets the target platform and the architecture. You select it when you [create a project](https://knowledge.bigenius-x.com/create-a-project?hsLang=en). - [Available Generator Configurations](https://knowledge.bigenius-x.com/available-generator-configurations?hsLang=en) lists the configurations by platform and links their profiles. - [Source systems per generator configuration](https://knowledge.bigenius-x.com/source-systems-per-generator-configurations?hsLang=en) lists the source system types of each configuration. - [Understand the Generator Configuration](https://knowledge.bigenius-x.com/understand-the-generator-configuration?hsLang=en) explains the concept. ### Configure and generate biGENIUS-X checks the model against business rules while you model. An error blocks generation in the client until you fix it, and a warning does not. - [Manage Project settings and Generator configuration](https://knowledge.bigenius-x.com/manage-project-settings-and-generator-configuration?hsLang=en) - [Generate artifacts](https://knowledge.bigenius-x.com/generate-artifacts?hsLang=en) - [Download generated artifacts](https://knowledge.bigenius-x.com/download-generated-artifacts?hsLang=en) - [Push the generated artifacts to repository](https://knowledge.bigenius-x.com/push-the-generated-artifacts-to-repository?hsLang=en) - [Understand warnings and errors](https://knowledge.bigenius-x.com/understand-warnings-and-errors?hsLang=en), with the index of all business rule articles - [Troubleshoot generation, deployment and load failures](https://knowledge.bigenius-x.com/troubleshoot-generation-deployment-and-load-failures?hsLang=en) ### Replace the placeholders and deploy The artifacts contain placeholders for the names and settings of your target environment. [Replace the placeholders in the artifacts](https://knowledge.bigenius-x.com/replace-the-placeholders-in-the-artifacts?hsLang=en) describes the replacement, and then you deploy. The dbt configurations have no replacement script: you set the values in `dbt_project.yml`, and the dbt run creates and loads the objects. Articles per platform, in the order you use them: - Microsoft SQL Server: [Target environment](https://knowledge.bigenius-x.com/microsoft-sql-server-target-environment?hsLang=en), [Artifacts](https://knowledge.bigenius-x.com/microsoft-sql-server-artifacts?hsLang=en), [Placeholder values](https://knowledge.bigenius-x.com/microsoft-sql-server-placeholder-values?hsLang=en), [Deployment](https://knowledge.bigenius-x.com/microsoft-sql-server-deployment?hsLang=en), [Delta Deployment with Liquibase](https://knowledge.bigenius-x.com/microsoft-sql-server-delta-deployment-with-liquibase?hsLang=en) - Snowflake: [Target environment](https://knowledge.bigenius-x.com/snowflake-target-environment?hsLang=en), [Artifacts](https://knowledge.bigenius-x.com/snowflake-artifacts?hsLang=en), [Placeholder values](https://knowledge.bigenius-x.com/snowflake-placeholder-values?hsLang=en), [Deployment](https://knowledge.bigenius-x.com/snowflake-deployment?hsLang=en), [Delta Deployment with Liquibase](https://knowledge.bigenius-x.com/snowflake-delta-deployment-with-liquibase?hsLang=en), [Deployment with an Azure Pipeline](https://knowledge.bigenius-x.com/snowflake-deployment-with-an-azure-pipeline?hsLang=en) - Snowflake dbt: [dbt - Artifacts](https://knowledge.bigenius-x.com/dbt-artifacts?hsLang=en), [dbt - Placeholder values](https://knowledge.bigenius-x.com/dbt-placeholder-values?hsLang=en), [dbt - Deployment](https://knowledge.bigenius-x.com/dbt-deployment?hsLang=en) (no target environment article available yet) - Databricks: [Target environment with the Hive metastore](https://knowledge.bigenius-x.com/databricks-target-environment?hsLang=en), [Target environment with Unity Catalog](https://knowledge.bigenius-x.com/databricks-unity-target-environment?hsLang=en), [Artifacts](https://knowledge.bigenius-x.com/databricks-artifacts?hsLang=en), [Placeholder values](https://knowledge.bigenius-x.com/databricks-placeholder-values?hsLang=en), [Deployment](https://knowledge.bigenius-x.com/databricks-deployment?hsLang=en), [Delta Deployment with Liquibase](https://knowledge.bigenius-x.com/databricks-delta-deployment-with-liquibase?hsLang=en) - Databricks dbt: [Target environment](https://knowledge.bigenius-x.com/databricks-dbt-target-environment?hsLang=en), [dbt - Artifacts](https://knowledge.bigenius-x.com/dbt-artifacts?hsLang=en), [dbt - Placeholder values](https://knowledge.bigenius-x.com/dbt-placeholder-values?hsLang=en), [dbt - Deployment](https://knowledge.bigenius-x.com/dbt-deployment?hsLang=en) - Fabric Lakehouse: [Target environment](https://knowledge.bigenius-x.com/fabric-lakehouse-target-environment?hsLang=en), [Artifacts](https://knowledge.bigenius-x.com/fabric-lakehouse-artifacts?hsLang=en), [Placeholder values](https://knowledge.bigenius-x.com/fabric-lakehouse-placeholder-values?hsLang=en), [Deployment](https://knowledge.bigenius-x.com/fabric-lakehouse-deployment?hsLang=en) - Fabric Lakehouse with Target Platform Azure Synapse: [Azure Synapse - Target environment](https://knowledge.bigenius-x.com/azure-synapse-target-environment?hsLang=en), [Placeholder values](https://knowledge.bigenius-x.com/fabric-lakehouse-placeholder-values?hsLang=en#azure-synapse), [Azure Synapse - Deployment](https://knowledge.bigenius-x.com/azure-synapse-deployment?hsLang=en) - Fabric Warehouse: [Target environment](https://knowledge.bigenius-x.com/fabric-warehouse-target-environment?hsLang=en), [Artifacts](https://knowledge.bigenius-x.com/fabric-warehouse-artifacts?hsLang=en), [Placeholder values](https://knowledge.bigenius-x.com/fabric-warehouse-placeholder-values?hsLang=en), [Deployment](https://knowledge.bigenius-x.com/fabric-warehouse-deployment?hsLang=en) - Oracle: [Target environment](https://knowledge.bigenius-x.com/oracle-target-environment?hsLang=en), [Artifacts](https://knowledge.bigenius-x.com/oracle-artifacts?hsLang=en), [Placeholder values](https://knowledge.bigenius-x.com/oracle-placeholder-values?hsLang=en), [Deployment](https://knowledge.bigenius-x.com/oracle-deployment?hsLang=en) Deployment tasks that apply to several platforms: [Delta deployment](https://knowledge.bigenius-x.com/do-a-delta-deployment?hsLang=en), [Do a partial deployment](https://knowledge.bigenius-x.com/do-a-partial-deployment?hsLang=en), [Deploy a Project in production](https://knowledge.bigenius-x.com/deploy-a-project-in-production?hsLang=en), [Test a Generator upgrade](https://knowledge.bigenius-x.com/test-a-generator-upgrade?hsLang=en). ### Load and monitor After the deployment, the load control of the solution runs the loaders in dependency order. [Understand Load Control](https://knowledge.bigenius-x.com/understand-load-control?hsLang=en) explains the options. Instead of the native load control, you can load with Apache Airflow where the platform offers it. A dbt project has no load control: each dbt run loads the models, as [dbt - Deployment](https://knowledge.bigenius-x.com/dbt-deployment?hsLang=en) describes. - Load control tasks: [Plan Load Control](https://knowledge.bigenius-x.com/plan-load-control?hsLang=en), [Configure Load Control](https://knowledge.bigenius-x.com/configure-load-control?hsLang=en), [Execute Load Control](https://knowledge.bigenius-x.com/execute-load-control?hsLang=en), [Monitor Load Control](https://knowledge.bigenius-x.com/monitor-load-control?hsLang=en) - Load control environments: [Native - Load control environment](https://knowledge.bigenius-x.com/native-load-control-environment?hsLang=en), [Apache Airflow - Load control environment](https://knowledge.bigenius-x.com/apache-airflow-load-control-environment?hsLang=en) - Microsoft SQL Server: [Native Load Control](https://knowledge.bigenius-x.com/microsoft-sql-server-load-data-native-load-control?hsLang=en), [Apache Airflow Load Control](https://knowledge.bigenius-x.com/microsoft-sql-server-load-data-apache-airflow-load-control?hsLang=en) - Snowflake: [Native Load Control](https://knowledge.bigenius-x.com/snowflake-load-data-native-load-control?hsLang=en), [Linked projects](https://knowledge.bigenius-x.com/snowflake-load-data-linked-projects?hsLang=en), [Apache Airflow Load Control](https://knowledge.bigenius-x.com/snowflake-load-data-apache-airflow-load-control?hsLang=en) - Databricks: [Native Load Control](https://knowledge.bigenius-x.com/databricks-load-data-native-load-control?hsLang=en), [Apache Airflow Load Control](https://knowledge.bigenius-x.com/databricks-load-data-apache-airflow-load-control?hsLang=en) - Fabric Lakehouse: [Native Load Control](https://knowledge.bigenius-x.com/fabric-lakehouse-load-data-native-load-control?hsLang=en), [Apache Airflow Load Control](https://knowledge.bigenius-x.com/fabric-lakehouse-load-data-apache-airflow-load-control?hsLang=en) - Fabric Lakehouse with Target Platform Azure Synapse: [Azure Synapse - Native Load Control](https://knowledge.bigenius-x.com/azure-synapse-load-data-native-load-control?hsLang=en) - Fabric Warehouse: [Native Load Control](https://knowledge.bigenius-x.com/fabric-warehouse-load-data-native-load-control?hsLang=en) - Oracle: [Native Load Control](https://knowledge.bigenius-x.com/oracle-load-data-native-load-control?hsLang=en), [Apache Airflow Load Control](https://knowledge.bigenius-x.com/oracle-load-data-apache-airflow-load-control?hsLang=en) - Snowflake dbt and Databricks dbt: [dbt - Deployment](https://knowledge.bigenius-x.com/dbt-deployment?hsLang=en) ### Model behavior These articles explain what the generated loaders do with your data: - [Understand the Layering concept](https://knowledge.bigenius-x.com/understand-the-layering-concept?hsLang=en) - [Understand the Generator target objects](https://knowledge.bigenius-x.com/understand-the-generator-target-objects?hsLang=en) - [How biGENIUS-X builds hash values](https://knowledge.bigenius-x.com/how-bigenius-x-builds-hash-values?hsLang=en) - [Change detection and historization](https://knowledge.bigenius-x.com/change-detection-and-historization?hsLang=en) - [Configure an incremental load](https://knowledge.bigenius-x.com/configure-an-incremental-load?hsLang=en) - [Configure delete detection](https://knowledge.bigenius-x.com/configure-a-delete-detection-behavior?hsLang=en) - [Configure a multi-version load](https://knowledge.bigenius-x.com/configure-a-multi-version-load?hsLang=en) - [Embryo Loader](https://knowledge.bigenius-x.com/embryo-loader?hsLang=en) - [Custom Singleton Values (Model Object)](https://knowledge.bigenius-x.com/custom-singleton-values-model-object?hsLang=en) - [Use Linked Projects](https://knowledge.bigenius-x.com/use-linked-projects?hsLang=en) ### References - Properties: [Generators: Properties](https://knowledge.bigenius-x.com/generators?hsLang=en#properties) - Default Terms: [Generators: Default Terms](https://knowledge.bigenius-x.com/generators?hsLang=en#default-terms) - Model object types: [Generators: Model Object Type](https://knowledge.bigenius-x.com/generators?hsLang=en#model-object-type) - Business rules: [Understand warnings and errors](https://knowledge.bigenius-x.com/understand-warnings-and-errors?hsLang=en) and [Best practices: Business Rules](https://knowledge.bigenius-x.com/best-practices?hsLang=en#business-rules) - Release notes: [Product Release Notes: Generators](https://knowledge.bigenius-x.com/product-release-notes?hsLang=en#generators) ### Related articles - Previous: [Create a Project](https://knowledge.bigenius-x.com/create-a-project?hsLang=en) - Next: [Generate artifacts](https://knowledge.bigenius-x.com/generate-artifacts?hsLang=en) - Reference: [Available Generator Configurations](https://knowledge.bigenius-x.com/available-generator-configurations?hsLang=en), [Source systems per generator configuration](https://knowledge.bigenius-x.com/source-systems-per-generator-configurations?hsLang=en) - See also: [Understand Load Control](https://knowledge.bigenius-x.com/understand-load-control?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) All rights reserved © 2025, biGENIUS AG