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 | |
|---|---|---|---|---|
| Create select * views (staging layer) from many raw data tables in different Snowflake schemas | 3 | 2278 | May 8, 2023 | |
| FIXED: Using dbt cloud, custom schemas using the generate_schema_name macro does not work | 0 | 1107 | April 22, 2024 | |
| Writing to a default schema | 3 | 691 | May 29, 2024 | |
| Having different value for 'THIS' variable when passing to macro using Post hook | 0 | 26 | March 7, 2025 | |
| [Obsolete] Creating a dev environment quickly on Snowflake | 6 | 18472 | September 13, 2021 |