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

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

You can read about our CTAS support here.