4. Strategies to create Surrogate keys in Spark-Databricks

[@radhakrishnanananthan1585]

Thanks for your video. May I kindly requesting you to let me know what is surrogate keys? where it is getting used.

[@arjunbattula1008]

Thanks for providing so much information and explaining it very good. I learned alot as I am working on the similar project which is creating notebooks.can you do videos on Data vault and dimensional modelling it will be helpful

[@seasql]

what is the your databricks runtime, direct identity column option avaiable from databricks runtime 10.3.. its latest staple release. you can check it out.. its not available when you developed that lecture.

[@arnabbangal766]

Did not get how the ID column is generated automatically ?
This is Bible for data engineers. Thanks a lot mam . Learnt a lot of important concepts.

[@prayasgupta7011]

Could you please provide the link to notebook that you have used in the video

[@subhamdas5609]

👍

[@EDWDB]

CREATE OR REPLACE TABLE demo (
id BIGINT GENERATED ALWAYS AS IDENTITY,
product_type STRING,
sales BIGINT
);

[@MohammedKhan-np7dn]

👍