Hi All,
Reference article - https://www.servicenow.com/community/developer-articles/integrate-snowflake-with-servicenow-using-jd...
I need to Grant a role to the user in Snowflake by ServiceNow. For that, we have one Catalog item and we get the user and role from the RITM Variables.
RITM Variable
User - Requested for
Role - SNF Role
We are passing the value in the data source (SQL Statement) using workflow. while data source testing we got this error. any suggestion what I need to do now?
We have done all the configurations that are mentioned in the below article. and we are using the 'GRANT ROLE' syntax to pass the value to the snowflake side.
Reference article - https://www.servicenow.com/community/developer-articles/integrate-snowflake-with-servicenow-using-jd...
Data Source SQL Query - GRANT ROLE FR_DEV_TEST_ABC_SRV_ETL TO USER TEST_1;
Role - FR_DEV_TEST_ABC_SRV_ETL
User - TEST_1
