How and When to Use Databricks Identity Column

Databricks added support for Identity Columns similar to the same feature found in relational databases. How do you use it? Should you use it? How does it differ from Identity columns on relational databases? Before you use the Identity Column feature, you need to watch this video.
Support me on Patreon
www.patreon.com/bePatron?u=63...
Video Slides
github.com/bcafferky/shared/b...
Delta Logs Video 1
• Understanding Delta Fi...
Delta Logs Video 2
• Understanding Delta Fi...
Delta Logs Video 3
• Understanding Delta Fi...

[@felipeporto4396]

This is pure gold

[@artus198]

yep, I come from SQL , we used identity all the time on PKs ... ! Thanks for the video.

[@user-fh8jo3us4t]

Partitioning by identity coliumn would be indeed a bad idea but if we had the partition by range feature, it could be interesting so that you partition by million or rows as an example...

[@mateen161]

Useful video. Thank you.

[@lunatyck05]

Should also mention if you try to insert a id value you will get an error when using GENERATED ALWAYS AS IDENTITY but you are able to use GENERATED BY DEFAULT and override identity or insert nulls into the column

[@BryanCafferky]

Hmmm.. I thought I did mention that but guess I was not clear. Thanks

[@MinPro-ws7ib]

Is the table managed or external?

[@BryanCafferky]

It's actually not relevant for this.