https://community.databricks.com/t5/data-engineering/external-table-on-databricks-using-dbt-data-build-tool-models/m-p/83528#M36951 <P>How can we create external tables in Databricks using DBT Models?</P> Tue, 20 Aug 2024 05:00:47 GMT hrushi512 2024-08-20T05:00:47Z https://community.databricks.com/t5/data-engineering/external-table-on-databricks-using-dbt-data-build-tool-models/m-p/83528#M36951 <P>How can we create external tables in Databricks using DBT Models?</P> Tue, 20 Aug 2024 05:00:47 GMT https://community.databricks.com/t5/data-engineering/external-table-on-databricks-using-dbt-data-build-tool-models/m-p/83528#M36951 hrushi512 2024-08-20T05:00:47Z https://community.databricks.com/t5/data-engineering/external-table-on-databricks-using-dbt-data-build-tool-models/m-p/83537#M36953 <P>Hi <a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/116659">@hrushi512</a>&nbsp;,</P><P>You can try to use location_root config parameter, as they did below:</P><P><A href="https://discourse.getdbt.com/t/add-location-to-create-database-schema-statement-in-databricks-to-enable-creation-of-managed-tables-on-external-storage-accounts/6894" target="_blank">https://discourse.getdbt.com/t/add-location-to-create-database-schema-statement-in-databricks-to-enable-creation-of-managed-tables-on-external-storage-accounts/6894</A></P> Tue, 20 Aug 2024 06:00:37 GMT https://community.databricks.com/t5/data-engineering/external-table-on-databricks-using-dbt-data-build-tool-models/m-p/83537#M36953 szymon_dybczak 2024-08-20T06:00:37Z