Creating Folders through SQL?

[patricker]

I know that I can create folders in spaces through the REST API, but is there a way to create folders in a space, or better yet a full path of folders , through SQL?

I would run this before running CREATE OR REPLACE view commands.

[ben]

Hi @patricker,
Currently, there is not a way to do this using a SQL command.

[patricker]

I ended up rolling my own, description/code here:

Custom SQL Command Parsing - With Example Code

Recently I wanted to create Spaces and Folders through SQL commands in Dremio, but found that it was not possible. I spent some time digging into the innards of how custom SQL commands and parsing work in Dremio, and implemented this functionality myself. For those of you comfortable with working with custom Dremio-OSS builds, I have included a link below to the commit, which shows an example of how to create a recursive space/folder SQL command. This could also be used as the basis for build…