David E. Wheeler
David E. Wheeler
Given that it's working in production, it seems like a configuration or permissions issue in your non-prod environment. You're certain that `$SNOWSQL_USER` has the permissions it needs, and that `$SNOWSQL_ROLE`...
The environment variables supported by Sqitch are documented in [sqitch-environment](http://sqitch.org/docs/manual/sqitch-environment/#snowflake); `SNOWSQL_NP_USER` and `SNOWSQL_NP_ACCOUNT` are not among them. I have not noticed use of `SQITCH_ROLE` in your examples, so it's not...
I'm afraid there is way more context for your particular environment than I can follow. Have you got it working? If so, what was the key to make it work?...
Yes, Sqitch supports that kind of url; see [here](https://github.com/sqitchers/sqitch/blob/d221719/.github/workflows/snowflake.yml#L32) for an example: ``` yaml SQITCH_TEST_SNOWFLAKE_URI: db:snowflake://${{ secrets.SNOWFLAKE_USERNAME }}:${{ secrets.SNOWFLAKE_PASSWORD }}@sra81677.us-east-1/sqitchtest?Driver=Snowflake;warehouse=compute_wh ``` The host name is `sra81677.us-east-1`. It could be that...
Ah, it could cause problems because the format of the URL, as far as I understand is, is ``` ...snowflakecomputing.com ``` So in your example, `abc` would be the account...
Looking at [the docs](https://docs.snowflake.com/en/user-guide/organizations-connect.html), it may be that you need to use a dash instead of a dot between `abc` and `def`: ``` abc-def.us-west-2.snowflakecomputing.com ``` That's assuming that `abc` is...
Before it creates the registry, Sqitch uses `SHOW server_version_num` to determine the version it's deploying to: https://github.com/sqitchers/sqitch/blob/9faa8421a7e9cf4545e07ce842b625f253ed3a62/lib/App/Sqitch/Engine/pg.pm#L208-L210 I can't see why that would be an issue; what version and build...
Did you ever get this issue resolved, @Doziadele?
I have done all the work to build RPMs on CentOS 6, and would be happy to contribute the requisite spec files. Anyone got an entrée to [EPEL](https://fedoraproject.org/wiki/EPEL) to submit...
Yes, I'll try to get that done this week.