Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Enable Account Task for Snowflake

Mortal
Regular Contributor
Regular Contributor

Hi,

Working on Snowflake integration, for enable account task, we have user update rule which triggers when the user is updated from import. We have condition when userstatuskey is updated and userstatuskey = 1 and action is enable user accounts.

After updating the statuskey from import the update rule will trigger but it will not create any task for the enable account. We have checked the logs as well for it although we found that the user update rule is triggering for the user but no statements of enable account task is getting created.

We are using the db connection type for it and the query is following:

{"enableaccountqry":["alter user ${accountName} set disabled=false;"]}

Thanks.

2 REPLIES 2

Amar_Simha
Regular Contributor
Regular Contributor

@Mortal : Can you try with below?

{
"EnableAccountQry" : "ALTER USER ${accountName} SET DISABLED = FALSE"
}

rushikeshvartak
All-Star
All-Star

Does json work when request raised from ARS / analytics


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.