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

[@AccountingatCHDS]

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

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

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

[@artus198]

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

[@mateen161]

Useful video. Thank you.

[@felipeporto4396]

This is pure gold

[@MinPro-ws7ib]

Is the table managed or external?

[@BryanCafferky]

It's actually not relevant for this.