topic Re: geometric functions in databricks in Data Engineering

geometric functions in databricks

koantek_user — Tue, 13 Aug 2024 05:11:08 GMT

Hi All,

We are working on a migration project from snowflake to databricks and there are some scripts that utilize
geometric functions like st_makepoint, st_geohash from snowflake scripts which we need to convert to databricks

Has some encountered this in their projects?

Re: geometric functions in databricks

szymon_dybczak — Tue, 13 Aug 2024 06:22:10 GMT

Hi @koantek_user ,

Look at below example notebook:

https://www.databricks.com/notebooks/geomesa-h3-notebook.html

And more info on processing geospatial data in databricks you can find below:

https://www.advancinganalytics.co.uk/blog/2023/1/3/gis-in-databricks

https://docs.databricks.com/en/sql/language-manual/sql-ref-h3-geospatial-functions.html

https://www.databricks.com/blog/2019/12/05/processing-geospatial-data-at-scale-with-databricks.html

Re: geometric functions in databricks

Retired_mod — Wed, 14 Aug 2024 08:02:48 GMT

Hi @koantek_user, Thanks for reaching out! Please review the response and let us know if it answers your question. Your feedback is valuable to us and the community.

If the response resolves your issue, kindly mark it as the accepted solution. This will help close the thread and assist others with similar queries.

We appreciate your participation and are here if you need further assistance!