Do everything in one place
Customize your SailPoint and Snowflake integration with the following
triggers and actions.
Triggers
When this happens…
SailPoint
- Access Request Dynamic Approval Real-timeRoute an access request to an additional approval step by an identity or a governance group.
- Access Request Postapproval Real-timeAn access request has passed all approval steps and is ready to be provisioned.
- Access Request Preapproval Real-timeApprove or deny an access request before it is sent to the first approver.
- Account Aggregation Completed Real-timeAn account aggregation operation has completed.
- Identity Attributes Changed Real-timeOne or more attributes for an identity have changed
- Identity Deleted Real-timeAn identity has been deleted in Identity Now.
- New Identity Created Real-timeA new identity has been created in Identity Now.
- Saved Search Completed Real-timeA report generated from a saved search subscription is available to be processed
Any other trigger you can think up
Snowflake
- New rowNew row in a table in Snowflake
- New rows BatchNew batch of rows in a table in Snowflake
- Scheduled query BatchScheduled query using custom SQL in Snowflake
- New/updated rowNew/updated row in a table in Snowflake
- New/updated rows BatchNew/updated batch of rows in a table in Snowflake
Any other trigger you can think up
Actions
Do this…
SailPoint
- Custom actionCustom action in SailPoint
- Get Account ActivityThis gets a single account activity.
- Get Certification CampaignThis gets a single certification campaign by ID.
- List Account ActivitiesThis gets a collection of account activities that satisfy the given parameters.
- List Certification CampaignsThis gets multiple certification campaigns that satisfy the given parameters.
- List Public IdentitiesReturns a list of publicly viewable identities in Identity Now.
- List Requestable ObjectsReturns a list of acccess items that that can be requested through the Submit Access Request action.
- Respond to TriggerThis will submit a response to a REQUEST_RESPONSE trigger.
- Submit Access RequestThis submits the access request into IdentityNow, where it will follow any IdentityNow approval processes.
- Upload Account Source FileThis uploads a CSV formatted account file generated from an identity source to Identity Now. IDN will automatically perform account aggregation when the file is received.
Any other action you can think up
Snowflake
- Bulk load data to table from stage BulkBulk load data to table from stage in Snowflake
- Delete rows BatchDelete rows in a table in Snowflake
- Export query resultExport query result as a CSV file in Snowflake
- Insert rowInsert row in a table in Snowflake
- Replicate schemaReplicate table schema in Snowflake
- Run custom SQL BatchRun custom SQL in Snowflake
- Run long query using custom SQLRun long query using custom SQL in Snowflake
- Select rows BatchSelect rows in a table in Snowflake
- Select rows using custom SQL BatchSelect rows using custom SQL in Snowflake
- Replicate rows BatchReplicate batch of rows to table in Snowflake
- Update rowsUpdate rows in a table in Snowflake
- Upload file to internal stageUpload file to internal stage in Snowflake
- Upsert rows BatchUpsert batch of rows in a table in Snowflake
Any other action you can think up
The wonders of Workato
Easily set up as many intelligent automations you need.
- 1000s of ready-to-use templates
- Accelerate work with intelligent automation
- Do it yourself, faster
- Build bots. Put them to work