in snowflake i want to test stored procedure for outputs

Question

salmon-actor-23953 · Answer

< stale crayon 83563> I m not sure I follow your use case Do you mind saying a bit more about what you are trying to do

stale-crayon-83563 · Answer

I have a very complex stored procedure that joins a ton of data together on demand I want to run through many test cases before new changes can be deployed

stale-crayon-83563 · Answer

someone suggested to me DBT unit tests

salmon-actor-23953 · Answer

Ah yes Got it Yes you ll want dbt schema tests and or data tests <https docs getdbt com docs building a dbt project tests>

salmon-actor-23953 · Answer

Those could then be run by something like `meltano invoke dbt test ` Might not have my syntax exactly correct but that s the basic idea