topic Re: st_point is disabled or unsupported. in Data Engineering

st_point is disabled or unsupported.

fundat — Tue, 23 Dec 2025 10:27:49 GMT

On my DLT pipeline,

I Installed the Databricks-mosaic library
Photon is activated
I'm using a workspace premium tier

SELECT id, city_name, st_point(latitude, longitude) AS city_point FROM city_data ;

st_point is disabled or unsupported. Consider enabling Photon or switch to a tier that supports ST expressions.

I understand well, to use GIS functions on ETL Pipeline we must have the Enterprise tier ?

Re: st_point is disabled or unsupported.

emma_s — Tue, 23 Dec 2025 11:37:37 GMT

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 you are using is DBR 17.1 or above, it is not currently supported on classic SQL warehouses either as it is still in public preview. https://docs.databricks.com/aws/en/sql/language-manual/functions/st_point

To check the version of runtime your pipeline is running on you can use the following code:

SELECT details:create_update:runtime_version:dbr_version FROM event_log_raw WHERE event_type = 'create_update

Re: st_point is disabled or unsupported.

fundat — Tue, 23 Dec 2025 12:19:53 GMT

Thank you for your answer @emma_s. So it can be difficult to set up a GIS dlt pipeline in Databricks ?

I can create multiple notebooks in which I used this GIS functions, according to my project, and create job in which I will associate each notebook with a task. So that to apply the GIS functions. Is that right ? But I will lose the incremental advantage.

Re: st_point is disabled or unsupported.

emma_s — Tue, 23 Dec 2025 13:38:06 GMT

Yes that will work, but yes you lose the incremental advantage. As soon as 17.1 is available in the preview channel in Declarative pipelines you'll be able to use it that way. Which should be very soon.

Re: st_point is disabled or unsupported.

fundat — Tue, 23 Dec 2025 19:15:46 GMT

Thank you @emma_s