Change Data Feed functionality from SQL Endpoint
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-03-2022 10:31 PM
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)
- Labels:
-
Change Data
-
Databricks Cluster
-
SQL
-
SQL Endpoint
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-03-2022 10:39 PM
what type of data source is underneath the table?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-03-2022 10:41 PM
Data source is Delta.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-03-2022 11:02 PM
I just noticed you want to do this from a sql endpoint.
I don´t think that is supported (yet).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-04-2022 03:08 AM
It is separate runtime https://docs.microsoft.com/en-us/azure/databricks/sql/release-notes/#channels
My blog: https://databrickster.medium.com/
