Foreign table to delta streaming table

ksenija
Contributor

I want to copy a table from a foreign catalog as my streaming table. This is the code I used but I am getting error: Table table_name does not support either micro-batch or continuous scan.;

 

spark.readStream
                .table(table_name)
                .writeStream
                .trigger(availableNow=True)
                .option("checkpointLocation", "dbfs:/folder_path")
                .toTable(new_table)