Add support for identity columns

[flvndh]

Describe the feature

Now that identity columns are GA, it would be great to be able to specify the identity column as part of the model configuration.

Describe alternatives you've considered

• monotonically_increasing_id()
• row_number()
• rank OVER
• hash()
• md5()

Who will this benefit?

Every dbt-databricks user who wants to generate surrogate keys.

Are you interested in contributing this feature?

Why not 😊

[mi-volodin]

I would vote for this. As it is a natural thing to use while creating DWH cores with entity-oriented normalized storage.

[github-actions[bot]]

This issue has been marked as Stale because it has been open for 180 days with no activity. If you would like the issue to remain open, please remove the stale label or comment on the issue.

[bayees]

Bump. Still relevant

[skywalker0618]

Bump, this will be very helpful.