https://community.databricks.com/t5/data-engineering/geometry-data-type-in-sql/m-p/92864#M38566 <P>Hi <a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/124834">@Shan_n</a>&nbsp;,</P><P>Databricks doesn't have native support for geometry data type. You can look at the list of all available data types below:&nbsp;</P><P><A href="https://docs.databricks.com/en/sql/language-manual/sql-ref-datatypes.html" target="_blank">https://docs.databricks.com/en/sql/language-manual/sql-ref-datatypes.html</A></P><P>But there is a way to work with geospatial data in spark. Refer to following blog post for more details:&nbsp;</P><P><A href="https://www.google.com/amp/s/www.advancinganalytics.co.uk/blog/2023/1/3/gis-in-databricks%3fhs_amp=true" target="_blank">https://www.google.com/amp/s/www.advancinganalytics.co.uk/blog/2023/1/3/gis-in-databricks%3fhs_amp=true</A></P> Sun, 06 Oct 2024 15:53:10 GMT szymon_dybczak 2024-10-06T15:53:10Z https://community.databricks.com/t5/data-engineering/geometry-data-type-in-sql/m-p/92834#M38553 <P>Hi All,</P><P>I am trying to create a table with Geometry datatype column in Databricks SQL.</P><P>Unfortunately, I am getting not supported data type error.</P><P>Is there any way I can create a table with Geometry datatype.&nbsp;</P><P>Thanks.</P> Sat, 05 Oct 2024 17:55:56 GMT https://community.databricks.com/t5/data-engineering/geometry-data-type-in-sql/m-p/92834#M38553 Shan_n 2024-10-05T17:55:56Z https://community.databricks.com/t5/data-engineering/geometry-data-type-in-sql/m-p/92864#M38566 <P>Hi <a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/124834">@Shan_n</a>&nbsp;,</P><P>Databricks doesn't have native support for geometry data type. You can look at the list of all available data types below:&nbsp;</P><P><A href="https://docs.databricks.com/en/sql/language-manual/sql-ref-datatypes.html" target="_blank">https://docs.databricks.com/en/sql/language-manual/sql-ref-datatypes.html</A></P><P>But there is a way to work with geospatial data in spark. Refer to following blog post for more details:&nbsp;</P><P><A href="https://www.google.com/amp/s/www.advancinganalytics.co.uk/blog/2023/1/3/gis-in-databricks%3fhs_amp=true" target="_blank">https://www.google.com/amp/s/www.advancinganalytics.co.uk/blog/2023/1/3/gis-in-databricks%3fhs_amp=true</A></P> Sun, 06 Oct 2024 15:53:10 GMT https://community.databricks.com/t5/data-engineering/geometry-data-type-in-sql/m-p/92864#M38566 szymon_dybczak 2024-10-06T15:53:10Z