cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

DLT- apply_changes() SCD2 - Rename_columns : __START_AT & __END_AT

VenkateswarluAd
New Contributor

 Renaming the column names of the __START_AT and __END_AT columns created when using the dlt.apply_changes() method for performing SCD2 type updates.

2 REPLIES 2

szymon_dybczak
Contributor III

Hi @VenkateswarluAd ,

I don't think it is possible to change those names. They are used internally by dlt framework and if you change them something definitely gonna break.

Ravivarma
Databricks Employee
Databricks Employee

Hello @VenkateswarluAd ,
Greetings of the day!

The columns __START_AT and __END_AT are used to track the validity period of each record for SCD Type 2 updates. Please be aware that renaming these columns could disrupt the functionality of the SCD Type 2 updates.

You can read more about this here: https://docs.databricks.com/en/delta-live-tables/cdc.html#how-is-cdc-implemented-with-the-apply-chan...

Regards,

Ravi

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group