Execute COPY INTO query with source as temp view

[HappySK]

We are having the files that needs to be loaded into the delta table

Now we want to perform some transformation on the files and load that into the table

What we did

1. Create a Spark DF from that file
2. Apply transformation on the DF
3. Create a temp view from the DF
4. Load the temp view using COPY INTO query as source

Will that be possible to use COPY Query in such a way ?

[ajaypanday6781]

Hi @Sravan Kumar Mohanraj​ ,

Yes, you can use copy query in this case your temp_view will be source.

For more info, please visit these links.