Replies: 1 comment
-
Here is the script to set up Snowflake account for tests: https://github.com/littleK0i/SnowDDL/blob/master/test/_sql/account_setup.sql Since we want to be able to actually run everything during testing, the SnowDDL admin role is derived from So.. this would let you run tests, but it creates another problem. Normal In order to mitigate this, you may create an additional "super-admin" role for human user and grant SnowDDL role to it. With this approach you'll be able to see objects created by tests in Snowflake GUI. Unfortunately, this is caused by fundamental flaws in Snowflake design, so I am currently not aware of any viable workarounds. CREATE ROLE SUPER_ADMIN;
GRANT ROLE SUPER_ADMIN TO USER <your_admin_user>;
ALTER USER <your_admin_user> SET DEFAULT_ROLE = SUPER_ADMIN;
GRANT ROLE ACCOUNTADMIN TO ROLE SUPER_ADMIN;
GRANT ROLE SNOWDDL_ADMIN_TEST TO ROLE SUPER_ADMIN; A few other tips about tests:
|
Beta Was this translation helpful? Give feedback.
-
Hi. I am trying to run the
run_test.sh
after running the following on a clean account:But the test script complains immediately with:
What's the right set up to run all the tests and see them pass? :)
I want to extend the test suite to include STREAM.
Beta Was this translation helpful? Give feedback.
All reactions