"Copy Into" Iceberg table in Dremio from Alteryx

[Hadzramin_Rahman]

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

[apathetichell]

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?

[Hadzramin_Rahman]

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