UUID/GUID Datatype in Databricks SQL

avidex180899
New Contributor III

‎12-20-2022 05:33 AM

Hi all,

I am trying to create a table with a GUID column.

I have tried using GUID, UUID; but both of them are not working.

Can someone help me with the syntax for adding a GUID column?

Thanks!

Labels:

Aviral-Bhardwaj
Esteemed Contributor III

‎12-20-2022 05:53 AM

Hey @Avinash Narasimhan​ ,

image.png 

What is the exact problem you are getting

can you please share it is working fine for me

Thanks

Aviral Bhardwaj

AviralBhardwaj

View solution in original post

Preview file
91 KB

avidex180899
New Contributor III
In response to Aviral-Bhardwaj

‎12-21-2022 12:05 AM

Hi @Aviral Bhardwaj​ ,

My issue has been resolved. So I was supposed to make one of my columns as a UUID data type. But then I decided to make it as a STRING data type and insert uuid's directly from the code and I am currently using that approach.

Thanks for your input!

Aviral-Bhardwaj
Esteemed Contributor III
In response to avidex180899

‎12-21-2022 02:38 AM

nice to know keep it up

AviralBhardwaj
0 Kudos

rswarnkar5
New Contributor III

‎08-20-2025 12:19 AM

> What ANSI SQL data structure to use for UUID or GUID?

I had similar question. The answer was `STRING`. 

0 Kudos