--- title: BG_DataflowName description: BG_DataflowName holds the name of the dataflow that a row of an increment table belongs to. --- [Skip to content](https://knowledge.bigenius-x.com/bg_dataflowname#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. [Default Terms](https://knowledge.bigenius-x.com/generators?hsLang=en#default-terms) # BG\_DataflowName **Applies to** Platform: Microsoft SQL Server · Snowflake · Databricks · Fabric Lakehouse · Fabric Warehouse · Oracle `BG_DataflowName` holds the name of the dataflow that a row of an increment table belongs to. Incremental loads use it to keep the progress of each dataflow apart. Its partner [BG\_DataflowSetName](https://knowledge.bigenius-x.com/bg_dataflowsetname?hsLang=en) holds the dataflow set. ### Objects that carry it - The increment table of Stage, the satellite types except the Record Tracking satellites, PIT, Business PIT, Fact and Mart Fact. The generator creates this table when the object uses an incremental load or a [Partition Filter](https://knowledge.bigenius-x.com/partition-filter-target-term?hsLang=en). - The Stage table of a Stage with an incremental load and [Increment Management Type](https://knowledge.bigenius-x.com/increment-management-type-model-object?hsLang=en) `Auto`. On Databricks and Fabric Lakehouse, also the Stage table of a Stage with only a Partition Filter, which holds NULL in `BG_DataflowName`. No other table carries it. Snowflake dbt and Databricks dbt have no increment table. ### Data type - Microsoft SQL Server: `nvarchar(255)` - Snowflake: `VARCHAR(255)` - Databricks, Fabric Lakehouse: `string` - Fabric Warehouse: `varchar(255)` - Oracle: `VARCHAR2(255)` ### Value The value is the name of the dataflow as the model shows it, for example `Dataflow1`. You do not map it; the generator fills it. - `Auto`: the deployment inserts one row per dataflow and dataflow set with the names and no filter value. On Microsoft SQL Server, Snowflake, Fabric Warehouse and Oracle, and for the model object types other than Stage on Databricks and Fabric Lakehouse, every row that a load adds carries the same names. Each load reads only the latest row of its own dataflow and dataflow set. - `User`: you insert the rows of the ranges yourself, with the names of the dataflow and the dataflow set. The load uses only the ranges with its own names. With `Auto` on Databricks and Fabric Lakehouse, the rows that a Stage load adds to the increment table hold NULL in `BG_DataflowName`. The next Stage load reads the latest row, regardless of its name. ### Example A Satellite on Microsoft SQL Server has two dataflows, `Dataflow1` and `Dataflow2`, each with the dataflow set `Set1`. Both read the same Stage and map [BG\_IncrementalFilter](https://knowledge.bigenius-x.com/bg_incrementalfilter?hsLang=en) to `UPDATE_DATE`. The `Dataflow1` load reads two source rows, the latest from 2026-01-12 09:00 UTC. After a row from 2026-01-15 09:00 UTC arrives, the `Dataflow2` load reads all three rows. The increment table holds, in UTC: ``` BG_ID BG_DataflowName BG_DataflowSetName BG_IncrementalFilter 1 Dataflow1 Set1 NULL 2 Dataflow2 Set1 NULL 3 Dataflow1 Set1 2026-01-12 09:00 4 Dataflow2 Set1 2026-01-15 09:00 ``` Rows 1 and 2 come from the deployment. The next `Dataflow1` load reads the source rows above 2026-01-12 09:00, the next `Dataflow2` load those above 2026-01-15 09:00. ### Related articles - Reference: [BG\_DataflowSetName](https://knowledge.bigenius-x.com/bg_dataflowsetname?hsLang=en), [BG\_ID](https://knowledge.bigenius-x.com/bg_id?hsLang=en), [BG\_IncrementalFilter](https://knowledge.bigenius-x.com/bg_incrementalfilter?hsLang=en), [Increment Management Type (Model Object)](https://knowledge.bigenius-x.com/increment-management-type-model-object?hsLang=en) - See also: [Configure an incremental load](https://knowledge.bigenius-x.com/configure-an-incremental-load?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