SNOWFLAKE SPOKE

[k4ktusk1nd]

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? 

[Dr Atul G- LNG]

Hi @k4ktusk1nd 

If you see the error:

'SERVICENOW_TECHNICAL_ROLE' specified in the connect string is not granted to this user. 
Contact your local system administrator, or attempt to log in with another role, 
e.g. PUBLIC. (sys_script_include.f6b59170472b19d0554ab988436d43c7.script; line 249)"

The issue is with the role you defined and that causing the issue in Script.Please check the lien 249. 

[k4ktusk1nd]

The referenced Script Include is the SnowflakeUtils Script that comes with the Snowflake Spoke and this just pastes the error message to the output of the spoke action. 

            if (statusCode == 400)

                throw new Error(

                    "Bad Request.The request payload is invalid or malformed." + "\n" + errorMessage

                );

Hence, this is direction seems not right. Any other recommendations? 

[Dr Atul G- LNG]

Hi @k4ktusk1nd 

Look like there is some syntax error in the payload and that is the reason it giving an error. Might be some where, or . is written.

[k4ktusk1nd]

The payload is formed by Actions contained in the Snowflake Spoke which I did not modify. 

The original question aims to find someone who had similar issues with the Snowflake spoke. Especially, why I cannot script the action inputs myself.