Creating Apache Iceberg tables with dbt-trino connector issue

Help
1

I am trying to create iceberg tables deployed to Trino with a hive metastore that writes to S3
Creating iceberg tables with Trino requires the following syntax…

Create materialized view <view name>
With (location = "s3://s3-bucket-path")
As
Select ....

The problem: I cannot find any documentation for what variable in the dbt-trino connector will allow me to inject the “With (location = …” part into my create table statement.

I’d like a variable to use in the model config block to specify different s3 end points for each model.

I am using dbt-trino and dbt-core 1.8.7

1 Like