ETL Freeze

Owned by Cortlandt _
Jun 24, 2023
2 min read

The Freeze feature protects/locks out data warehouse tables from accidental changes to the data in the target (data warehouse) table. Useful for static tables or tables with historical data that should never be overwritten.

Select Freeze to prevent all changes in ETL+ related to this target table.

When selected the Freeze checkbox doesn't allow any action on the target table. It reezes the (target) table (in the data warehouse). A job on the can includes a frozen target table but log file will record any action on the table with the words “Skip. This table is frozen."

On the selecting Freeze on a target table will inactivate the Load All button, the Extract SQL Statement panel, the Design page, and the target table name on the Target Object panel.

 


More Advanced Options for Protecting Data in SQL Server

For more advanced users with SQL Server administration capabilities who want to provide a higher level of protection to unchanging, static, or archived historical data.
To provide a higher level of protection make the table Read Only. For instance see https://stackoverflow.com/questions/2529839/how-to-make-a-table-read-only-in-sql-server

Â