Delta live table UC Kinesis: options overwriteschema, ignorechanges not supported for data sourc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-03-2023 11:25 PM - edited 07-03-2023 11:25 PM
I try to build a DLT in UC with Kinesis as producer.
My first table looks like:
@dlt.create_table(
table_properties={
"pipelines.autoOptimize.managed": "true"
},
spark_conf={"spark.databricks.delta.schema.autoMerge.enabled": "true"},
)
def feed_chunks():
return (
spark.readStream.format("kinesis")
.option("streamName", stream_name)
.option("ignoreChanges", "true")
.option("overwriteSchema", "true")
.option("roleArn", "arn:aws:iam::xxxxx:role/xxxxx-read-role")
.option("region", "eu-west-1")
.load()
)
And I get this error:
pyspark.errors.exceptions.AnalysisException: [UNSUPPORTED_STREAMING_OPTIONS_PERMISSION_ENFORCED]
Streaming options overwriteschema, ignorechanges are not supported for
data source kinesis on a shared cluster.
Is this a know limitation of DLT x UC ?
The same DLT with simple hive metastore works fine.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-30-2023 01:08 PM
Hi,
Did you found a solution ? I have the same problem
Thanks !
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-23-2023 06:43 AM
If you use the "Preview" Channel in the "Advanced" section of the DLT Pipeline, this error should resolve itself. This fix is planned to make it into the "Current" channel by Aug 31, 2023
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-04-2023 05:01 AM
Hello !
My pipeline is already in Advanced mode because I'm using Unity Catalog in storage options

