In order to provide CI/CD features to dremio, I am trying to leverage dbt on dremio, and had a little success. In datalakes, CREATE TABLE will silently create the folder, but nope for CREATE VIEW in spaces. Now dremio is really missing standard CREATE/DROP SCHEMA DDL commands.With these commands, we could use dbt to fully automate shared or user spaces upgrades, version control entire dremio projects, and even use a CI/CD approach.
Could it be possible to see these commands available in near future ?
CREATE [IF NOT EXISTS] SCHEMA|FOLDER “my_space”.“my_subspace”
DROP [IF EXISTS] SCHEMA|FOLDER “my_space”.“my_subspace” [CASCADE]
Once again, thank you for providing us with such a great tool !