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 | |
|---|---|---|---|---|
| target db/schema and profile is hidden or uncomprehending | 0 | 32 | September 9, 2025 | |
| Macro called in post hook does not use the correct schema | 0 | 37 | November 13, 2025 | |
| Create select * views (staging layer) from many raw data tables in different Snowflake schemas | 3 | 2377 | May 8, 2023 | |
| FIXED: Using dbt cloud, custom schemas using the generate_schema_name macro does not work | 0 | 1265 | April 22, 2024 | |
| Writing to a default schema | 3 | 867 | May 29, 2024 |