"Copy Into" Iceberg table in Dremio from Alteryx

Question

Hi,
Does anyone have experience running SQL "Copy Into" in Alteryx to update Dremio?

I have tried searching for it, but have had no luck so far.

Thanks,
Amin

Hadzramin_Rahman · Answer

Let me try and get back to you with the result.

apathetichell · Answer

Copy into would not be supported by In-database syntax - you could write directly to a table - but you could not use Copy Into - which is used to copy from a staging location into a table. You could try it in PreSQL/PostSQL etc on canvas using input data our outpdut data. What error are you seeing?