Hello All, I’m new to dbt. I’m trying to deploy a Snowflake stored procedure via Macro in dbt Cloud. I’ve created a macro for the respective stored procedure and invoking the macro from project.yml(on-run-start:). It’s creating the stored procedure in Snowflake BUT in the default schema, not the one I would like it to be created. Please advise me on how to customize the schema for Macros??
Related Topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| [Obsolete] Creating a dev environment quickly on Snowflake | 6 | 16422 | September 13, 2021 | |
| Snowpipe with dbt | 0 | 1508 | August 16, 2023 | |
| Custom materialization - Run DDL on snowflake -- Error | 2 | 972 | January 25, 2023 | |
| DBT wont drop SCHEMAS in snowflake | 2 | 965 | April 22, 2023 | |
| Managing hundreds of schemas in the dbt_project.yml | 5 | 3164 | August 26, 2022 |