https://community.databricks.com/t5/data-engineering/execute-copy-into-query-with-source-as-temp-view/m-p/4067#M891 <P>Hi @Sravan Kumar Mohanraj​&nbsp;,</P><P></P><P>Yes, you can use copy query in this case your temp_view will be source.</P><P></P><P>For more info, please visit <A href="https://docs.databricks.com/sql/language-manual/delta-copy-into.html" alt="https://docs.databricks.com/sql/language-manual/delta-copy-into.html" target="_blank">these links.</A></P> Tue, 23 May 2023 13:35:04 GMT Ajay-Pandey 2023-05-23T13:35:04Z https://community.databricks.com/t5/data-engineering/execute-copy-into-query-with-source-as-temp-view/m-p/4066#M890 <P>We are having the files that needs to be loaded into the delta table</P><P>Now we want to perform some transformation on the files and load that into the table</P><P>What we did</P><OL><LI>Create a Spark DF from that file</LI><LI>Apply transformation on the DF</LI><LI>Create a temp view from the DF</LI><LI>Load the temp view using COPY INTO query as source</LI></OL><P></P><P>Will that be possible to use COPY Query in such a way ?</P> Tue, 23 May 2023 09:04:38 GMT https://community.databricks.com/t5/data-engineering/execute-copy-into-query-with-source-as-temp-view/m-p/4066#M890 HappySK 2023-05-23T09:04:38Z https://community.databricks.com/t5/data-engineering/execute-copy-into-query-with-source-as-temp-view/m-p/4067#M891 <P>Hi @Sravan Kumar Mohanraj​&nbsp;,</P><P></P><P>Yes, you can use copy query in this case your temp_view will be source.</P><P></P><P>For more info, please visit <A href="https://docs.databricks.com/sql/language-manual/delta-copy-into.html" alt="https://docs.databricks.com/sql/language-manual/delta-copy-into.html" target="_blank">these links.</A></P> Tue, 23 May 2023 13:35:04 GMT https://community.databricks.com/t5/data-engineering/execute-copy-into-query-with-source-as-temp-view/m-p/4067#M891 Ajay-Pandey 2023-05-23T13:35:04Z