in snowflake, i want to test stored procedure for ...
# announcementss
seth_therrien
04/14/2021, 6:53 PMin snowflake, i want to test stored procedure for outputs
a
aaronsteers
04/14/2021, 7:26 PM@seth_therrien - I’m not sure I follow your use case. Do you mind saying a bit more about what you are trying to do?
s
seth_therrien
04/14/2021, 7:27 PMI 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
seth_therrien
04/14/2021, 7:27 PMsomeone suggested to me DBT unit tests
a
aaronsteers
04/14/2021, 7:29 PMAh yes. Got it. Yes, you’ll want dbt schema tests and/or data tests: https://docs.getdbt.com/docs/building-a-dbt-project/tests
aaronsteers
04/14/2021, 7:30 PMThose could then be run by something like
meltano invoke dbt test …16 Views