dremio-oss icon indicating copy to clipboard operation
dremio-oss copied to clipboard

Add `CREATE FOLDER $ RECUSRIVE` SQL Support

Open fabrice-etanchaud opened this issue 5 years ago • 3 comments

Peter Wicks took time to implement a CREATE FOLDER SQL command, it would be great to take that into account and provide every dremio user with this command. This will allow us to automate dataset transformations from sources to enduser marts, using for example : dbt-dremio

fabrice-etanchaud avatar Sep 19 '20 14:09 fabrice-etanchaud

@fabrice-etanchaud Thanks for the kind words about my code. I'm happy you have found it useful. We use this for automating our deployments. We store all Virtual Datasets in Git, and include the Space/Folder creation scripts at the top.

patricker avatar Sep 20 '20 00:09 patricker

@patricker, did you have a look at my implementation of a dbt adapter for dremio ? Would you find that useful ?

fabrice-etanchaud avatar Sep 21 '20 13:09 fabrice-etanchaud

@fabrice-etanchaud, I'll be sure to take a look, but I have never used dbt before.

patricker avatar Sep 21 '20 17:09 patricker