Replies: 3 comments
-
The Sqitch user may not have there permissions to create it. On connection it resumes and uses the warehouse: sqitch/lib/App/Sqitch/Engine/snowflake.pm Lines 213 to 214 in 9074a94 |
Beta Was this translation helpful? Give feedback.
-
Right now there is no way to execute Sqitch without first creating a warehouse in a new account. I think it would improve the usability of Sqitch if the option at least existed. The idea is to automate as much of the DB creation as possible. This mod enables DB creation without a user ever logging in to a new account manually. |
Beta Was this translation helpful? Give feedback.
-
Yeah, early on I made the decision that sqitch would not create databases. Too many people wrote in for my other projects to complain that there were errors because they already had databases and limited permissions. |
Beta Was this translation helpful? Give feedback.
-
A nice-to-have feature would be the auto-creation of the requested Snowflake warehouse.
As a user of Sqitch I would like to execute Sqitch on a newly created Snowflake account without having to create a warehouse manually first.
Currently new accounts have an ACCOUNTADMIN user, but no warehouses. This poses a chicken/egg problem, where I want Sqitch to create warehouses, but it can't do that until a warehouse exists.
Maybe add a "-w" flag or "--create-warehouse" to the command line that would trigger the execution of the following commands before anything else:
CREATE WAREHOUSE if not exists &warehouse WITH WAREHOUSE_SIZE = 'XSMALL' WAREHOUSE_TYPE = 'STANDARD' AUTO_SUSPEND = 30 AUTO_RESUME = TRUE;
USE WAREHOUSE &warehouse;
Beta Was this translation helpful? Give feedback.
All reactions