5

Would it be possible to run local instance of snowflake inside docker container? We need to add test cases for the sql scripts written it in snowsql. If it is not possible to run local instance of snowflake inside docker container then is there any alternative to perform tests against sql scripts?

Prashant Kamble
  • 65
  • 1
  • 8
  • 3
    No. Snowflake is a SSaS product, you can’t run your own installation of Snowflake. Why would you want to - why can’t you test your scripts against your normal Snowflake instance? – NickW Mar 23 '23 at 09:04
  • Could you please elaborate normal Snowflake instance mean? Do you mean to test against live DB instead local? – Prashant Kamble Mar 23 '23 at 09:47
  • 1
    No - not against your live DB. A snowflake account can contain multiple DBs, so you can have Dev, Test and Prod DBs in the same account. Alternatively (and, in my opinion, an architecturally better solution) you can run multiple Snowflake accounts - so have a Dev account, a Test account and a Prod account – NickW Mar 23 '23 at 10:44

0 Answers0