Alternative to Identity columns in Warehouse

[Trystan]

Hello,

What is an alternative way to generate an identity column when using a Warehouse?

Thanks.

[puneetvijwani · Accepted solution]

@Trystan  you can use ROW_NUMBER() to mannually generate them via sql queries and add the data in your table

Ps: If my response helped, kindly select it as the solution. Your kudos are greatly appreciated!