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.co...
Video Slides
github.com/bca...
Delta Logs Video 1
• Understanding Delta Fi...
Delta Logs Video 2
• Understanding Delta Fi...
Delta Logs Video 3
• Understanding Delta Fi...

[@NoahPitts713]

Great and timeless info as always! qq - how has your experience been using the IDENTITY Column since making this video?

[@BryanCafferky]

I have not dared to try it again. lol I don't think it is the best idea for a scaled out service to be honest. Ok if updates are limited but I would still try to find an alternative.

[@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...

[@felipeporto4396]

This is pure gold

[@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

[@mateen161]

Useful video. Thank you.

[@MinPro-ws7ib]

Is the table managed or external?

[@BryanCafferky]

It's actually not relevant for this.