topic Re: UUID/GUID Datatype in Databricks SQL in Data Engineering

UUID/GUID Datatype in Databricks SQL

avidex180899 — Tue, 20 Dec 2022 13:33:51 GMT

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!

Re: UUID/GUID Datatype in Databricks SQL

Aviral-Bhardwaj — Tue, 20 Dec 2022 13:53:37 GMT

Hey @Avinash Narasimhan ,

What is the exact problem you are getting

can you please share it is working fine for me

Thanks

Aviral Bhardwaj

Re: UUID/GUID Datatype in Databricks SQL

avidex180899 — Wed, 21 Dec 2022 08:05:15 GMT

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!

Re: UUID/GUID Datatype in Databricks SQL

Aviral-Bhardwaj — Wed, 21 Dec 2022 10:38:48 GMT

nice to know keep it up

Re: UUID/GUID Datatype in Databricks SQL

rswarnkar5 — Wed, 20 Aug 2025 07:19:08 GMT

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

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