Hello,
I tried integrating Snowflake with ServiceNow via the recently released Snowflake Spoke.
Unfortunately the spoke actions do not load all the dynamic action inputs (like warehouses, database etc) assigned to the user (Screenshot).
Here, the dynamic action input correctly fetches the Role from the Snowflake Instance for the TEST_SERVICE User.
But then the Warehouse, Database, Schema and additional Parameters are not fetched.
When I test the Get Warehouse Spoke Action with the Parameters User ID = TEST_SERVICE and Role = SERVICENOW_TECHNICAL_ROLE I get the following error Message:
{
"Action Status": {
"code": 1,
"message": "Error: Bad Request.The request payload is invalid or malformed.\nRole 'SERVICENOW_TECHNICAL_ROLE' specified in the connect string is not granted to this user. Contact your local system administrator, or attempt to login with another role, e.g. PUBLIC. (sys_script_include.f6b59170472b19d0554ab988436d43c7.script; line 249)"
}
}
Secondly, I previously was able to script the inputs to the spoke action (instead of relying on the dynamic action inputs). But now the script option is not available anymore:
Any suggestions on how I can make the spoke work?
