I am trying to reverse ETL datasets from Dremio into Azure Blob Storage using dbt. I found this article describing how to do it: https://www.dremio.com/resources/tutorials/high-performance-parallel-exports/#toc_item_Introduction
I configured my source with CTAS support per the article.
However, when I execute a query like the following:
create table "Data Lake"."04-dir"."application"."retl" as ( WITH input_mart AS ( SELECT * FROM "data mart"."application"."input_data" ) SELECT * FROM input_mart )
I get an error:
Cannot create the table because '04-dir' container does not exist.
The container definitely exists so not sure why Dremio thinks it doesn’t.
Still on an ancient version of Dremio so maybe this is a bug. Waiting for Dremio Cloud Azure to come out before upgrading.
Thanks for your help!