Snowflake SaaS - Aggregation error DEFAULT_NAMESPACE

SailPoint Human Fabric (SHF) SHF Discussion and Questions
,
1

We are attempting to stand up a new version of our Snowflake Connector, = 0 moving from VA-based to SaaS based and getting the following error when trying to aggregate accounts. Note that test connection works correctly.

Error!
[ConnectorError] 422 [Possible Suggestion]Please check the account or role filter syntax [Error] ERR_BAD_REQUEST, Request failed with status code 422, Unprocessable Entity, {"code":"391920","message":"Unable to run the command. You must specify the warehouse to use by either setting the warehouse field in the body of the request or by setting the DEFAULT_NAMESPACE property for the current user.","sqlState":"57P03","statementHandle":"01c53e3e-081e-c28b-0072-d5835146db12"} (requestId: 2caf9319062c427da52c6f728755fd70
  • The Snowflake team assures me that the previous connection and account did not require this setting and that they do not set a default for any other account types.

In an effort to validate this, we entered the same credentials, secret, and passphrase on the old VA based connection and now that connection receives this message during test connection.

Error Received:

[ InvalidConfigurationException ] [ Possible suggestions ] snowflake_err_invalid_credentials [ Error details ] Error occurred while creating auth token

2

any openssl configured? I mean have you generated keys using OpenSSL.

3

I believe that the easiest solution for this is for the Snowflake team to add the Default Warehouse to the Service Account user that you connect to Snowflake with. This should allow the queries by the user to have this set automatically.

Sometimes the Test Connections only check that the service Endpoint returns a response, and not necessarily that it can make requests. Similarly, this could be a change on the snowflake side to require this now in your tenant where it was not necessary before, especially if you moved to a SaaS based Snowflake instance at the same time.

Some general knowledge on the Snowflake warehouses: Snowflake Virtual Warehouses Explained: Size, Scaling & Best Practices