st_point is disabled or unsupported.

fundat
New Contributor III

‎12-23-2025 02:27 AM

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 ?

0 Kudos

emma_s
Databricks Employee
Databricks Employee

‎12-23-2025 03:37 AM

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

 

fundat
New Contributor III
In response to emma_s

‎12-23-2025 04:19 AM

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.

0 Kudos

emma_s
Databricks Employee
Databricks Employee
In response to fundat

‎12-23-2025 05:38 AM

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.

View solution in original post

fundat
New Contributor III
In response to emma_s

‎12-23-2025 11:15 AM

Thank you @emma_s 

0 Kudos