Skip to main content

Stage On Extract

Determines if the Azure-based Extract and Load process runs the stage process for the extracted data in the destination database. When set to Y (the default), the stage pipeline of an Azure Data Factory or Microsoft Fabric Data Factory project runs the staging stored procedure as its own step, after the copy of the extract or, when the project uses Pushdown Extraction, in place of the copy, for each source object whose staging table is on SQL Server, Azure SQL Database, Azure Synapse, Azure SQL Managed Instance, a Fabric Warehouse or a Fabric SQL Database. A staging table on Snowflake gets that step whatever this setting says.

With N, the stage pipeline of such a source object holds no staging step. In an Azure Data Factory or Microsoft Fabric Data Factory project, the build gives the warning OBJ_27005005 for each source object that loads the Data Vault with this setting off and the Data Vault setting Process On Stage on while its staging table is on SQL Server, Azure SQL Database, Azure Synapse, Azure SQL Managed Instance, a Fabric Warehouse or a Fabric SQL Database, because its stage pipeline then runs the Data Vault step with no staging step before it.

Notes:

  • This setting is part of the Azure settings category.
  • The default value for this setting is Y.