- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-06-2024 12:30 AM
Hi @lakshgisprog ,
In databricks there is no GEOGRAPHY data type.
Please check the documentation for the available data types:
https://docs.databricks.com/en/sql/language-manual/sql-ref-datatypes.html
What you can do is:
1. You can store GEOGRAPHY as BINARY or STRING in delta table
2. After reading the data from the table you will convert it in your Node JS application into GEOGRAPHY data type
Also, for transformations on Databricks side you should be able to use ST expressions and H3 library on the shared cluster with photon-enabled clusters, as H3 library is installed by default:
https://learn.microsoft.com/en-us/azure/databricks/sql/language-manual/sql-ref-h3-geospatial-functio...