by
fundat
• New Contributor III
- 157 Views
- 4 replies
- 2 kudos
On my DLT pipeline,I Installed the Databricks-mosaic libraryPhoton is activatedI'm using a workspace premium tierSELECT
id,
city_name,
st_point(latitude, longitude) AS city_point
FROM city_data
;st_point is disabled or unsupported. Co...
- 157 Views
- 4 replies
- 2 kudos
Latest Reply
DLT pipelines are still on runtime 16.4 which doesn't have support for st_point yet. See details here https://learn.microsoft.com/en-us/azure/databricks/release-notes/dlt/
You should be able to use st_point in normal SQL editor as long as the cluster...
3 More Replies
- 153 Views
- 1 replies
- 0 kudos
Regarding the limitations of declarative pipelines—specifically the inability to use replaceWhere—I discovered through testing that materialized views actually support dynamic overwrites. This handles several scenarios where replaceWhere would typica...
- 153 Views
- 1 replies
- 0 kudos
Latest Reply
This is a really interesting find, and honestly not something most people expect from materialized views.Under the hood, MVs in Databricks declarative pipelines are still Delta tables. So when you set partitionOverwriteMode=dynamic and partition by a...