How can I append a virtual dataset query to a physical dataset table

Dremio University
1

I’m looking for a process where I can schedule a Dremio query to run once a month and append the records to a separate file/table located in my hdfs directory.

Would like to explore create table command in query, but unsure where to begin with formatting of directory structure

2

You can read about our CTAS support here.