Foreign table to delta streaming table

[ksenija]

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)

[MLE123]

Bumping this thread because I have the same question and this is still the first result on Google (c. October 2024). Many thanks for anyone who is able to assist!