topic Re: Change Data Feed functionality from SQL Endpoint in Data Engineering

Change Data Feed functionality from SQL Endpoint

Suman — Fri, 04 Mar 2022 06:31:08 GMT

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- — Fri, 04 Mar 2022 06:39:30 GMT

what type of data source is underneath the table?

Suman — Fri, 04 Mar 2022 06:41:05 GMT

Data source is Delta.

-werners- — Fri, 04 Mar 2022 07:02:43 GMT

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

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

Hubert-Dudek — Fri, 04 Mar 2022 11:08:09 GMT