Geometry Data type in sql

[Shan_n]

Hi All,

I am trying to create a table with Geometry datatype column in Databricks SQL.

Unfortunately, I am getting not supported data type error.

Is there any way I can create a table with Geometry datatype. 

Thanks.

[szymon_dybczak]

Hi @Shan_n ,

Databricks doesn't have native support for geometry data type. You can look at the list of all available data types below: 

https://docs.databricks.com/en/sql/language-manual/sql-ref-datatypes.html

But there is a way to work with geospatial data in spark. Refer to following blog post for more details: 

https://www.google.com/amp/s/www.advancinganalytics.co.uk/blog/2023/1/3/gis-in-databricks%3fhs_amp=t...