https://community.databricks.com/t5/data-engineering/is-it-possible-to-set-order-of-precedence-of-spark-sql/m-p/21315#M14515 <P>This does help. I tried going through the DataFrameReader as well but ran into the same error, so it seems it is indeed not possible. Thank you @Hubert Dudek​!</P> Fri, 13 May 2022 17:12:08 GMT samrachmiletter 2022-05-13T17:12:08Z https://community.databricks.com/t5/data-engineering/is-it-possible-to-set-order-of-precedence-of-spark-sql/m-p/21312#M14512 <P>I have the iceberg SQL extension installed, but running commands such as MERGE INTO result in the error </P><PRE><CODE>pyspark.sql.utils.AnalysisException: MERGE destination only supports Delta sources.</CODE></PRE><P>this seems to be due to using <A href="https://docs.databricks.com/spark/latest/spark-sql/language-manual/delta-merge-into.html?_ga=2.118084361.1411576470.1651788707-2044037470.1637080172" alt="https://docs.databricks.com/spark/latest/spark-sql/language-manual/delta-merge-into.html?_ga=2.118084361.1411576470.1651788707-2044037470.1637080172" target="_blank">Delta's</A> MERGE command as opposed to <A href="https://iceberg.apache.org/docs/latest/spark-writes/#merge-into" alt="https://iceberg.apache.org/docs/latest/spark-writes/#merge-into" target="_blank">Iceberg's</A>. Is it possible to force use of the Iceberg extension before Databricks' own?</P> Fri, 06 May 2022 18:44:07 GMT https://community.databricks.com/t5/data-engineering/is-it-possible-to-set-order-of-precedence-of-spark-sql/m-p/21312#M14512 samrachmiletter 2022-05-06T18:44:07Z https://community.databricks.com/t5/data-engineering/is-it-possible-to-set-order-of-precedence-of-spark-sql/m-p/21313#M14513 <P>@Sam Rachmil-Etter​&nbsp;, SQL syntax is "Databricks" one so I am afraid it will not work. CONVERT can transform the iceberg parquet into the delta.</P><P></P><P>Probably in python/scala it could be better as format("iceberg") can be used in DataFrameReader but I have no experience with iceberg on databricks.</P><P></P> Sat, 07 May 2022 11:02:25 GMT https://community.databricks.com/t5/data-engineering/is-it-possible-to-set-order-of-precedence-of-spark-sql/m-p/21313#M14513 Hubert-Dudek 2022-05-07T11:02:25Z https://community.databricks.com/t5/data-engineering/is-it-possible-to-set-order-of-precedence-of-spark-sql/m-p/21315#M14515 <P>This does help. I tried going through the DataFrameReader as well but ran into the same error, so it seems it is indeed not possible. Thank you @Hubert Dudek​!</P> Fri, 13 May 2022 17:12:08 GMT https://community.databricks.com/t5/data-engineering/is-it-possible-to-set-order-of-precedence-of-spark-sql/m-p/21315#M14515 samrachmiletter 2022-05-13T17:12:08Z