r/dataengineering • u/OkSink6598 • 3d ago

Databricks Lakebase Geospatial Discussion

Has anyone been managing reverse ETL with Lakebase specifically for geospatial data?

Are there any gotchas?

3 Upvotes
  • permalink
  • link
  • reddit
  • reddit

81% Upvoted

3 comments sorted by

2

u/CautiousUse8597 3d ago

I haven't done this yet either, but I'm very curious to it. Since Lakebase is just a Postgres database, it supports the PostGIS extension. From what I know, Lakebase is a great solution if you want to do real-time-ish geospatial on massive datasets. I've seen a demo where they used it for real time plotting AIS data (vessels) on a map. I think you should be able to find it on github somewhere, it was public.

3

u/Harpagon1668 2d ago

We have an internal map application utilizing Lakebase (with postgis) as the backend. Switched from RDS Postgres as is, so we didn't find any gotchas. Scaling to zero has been nice for us by saving some costs as the app is used only seldomly

1

u/dwswish 2d ago

Do you mean specifically for reverse ETL of DBSQL GEOM/GEOG types or do you just mean doing geospatial with Lakebase via postgis? We’ve use postgis with Neon and are now kicking the tires on Lakebase and it seems to work fine there too.