Change Data Feed functionality from SQL Endpoint

[Suman]

I am trying to run command to retrieve change data from sql endpoint. It is throwing below error.

"The input query contains unsupported data source(s).Only csv, json, avro, delta, parquet, orc, text data sources are supported on Databricks SQL."

But the same query is running from Databricks cluster (cluster version 9.1 LTS)

Query is as below

SELECT * FROM table_changes('<table name>', 1,2)

[-werners-]

what type of data source is underneath the table?

[Suman]

Data source is Delta.

[-werners-]

I just noticed you want to do this from a sql endpoint.

I don´t think that is supported (yet).

[Hubert-Dudek]

It is separate runtime https://docs.microsoft.com/en-us/azure/databricks/sql/release-notes/#channels

[Kaniz · Accepted solution]

Hi @Suman Chowdhury​ , Change Data Feed is only available in Databricks Runtime 8.4 and above.