JupiterOne Data Ingestion and Snowflake integration | Workato

Market leaders run on Workato

Build Powerful Workflows, fast

Triggers

When this happens…

Snowflake

New row
New row in a table in Snowflake
New rows Batch
New batch of rows in a table in Snowflake
Scheduled query Batch
Scheduled query using custom SQL in Snowflake
New/updated row
New/updated row in a table in Snowflake
New/updated rows Batch
New/updated batch of rows in a table in Snowflake

Any other trigger you can think up

Actions

Do this…

JupiterOne Data Ingestion

Abort Sync Job
Aborts an active sync job, discarding all uploaded data. Use this to cancel a job that should not be finalized.
Bulk Delete Entities
Sends a bulk delete request for entities within an active sync job. Provide an array of objects containing entity _id values to delete.
Create Integration Instance
Creates a new custom integration instance for use with the Sync API. Returns the instance ID needed for starting sync jobs.
Finalize Sync Job
Finalizes a sync job, triggering the JupiterOne backend to process and apply all uploaded entities and relationships to the graph. Call this after all upload actions are complete.
Start Sync Job
Starts a new synchronization job. Use source "integration-external" with an integration instance ID (scope is derived from the instance). Use source "api" with an explicit scope value (no integration instance). Returns the job ID needed for uploading data and finalizing.
Upload Combined Batch
Uploads a batch of entities and/or relationships to an active sync job in a single API call. At least one of entities or relationships must be provided.
Upload Entities Batch
Uploads a batch of entities to an active sync job. Recommended batch size: 250-500 entities per call. Each entity requires _key, _type, _class, and displayName at minimum.
Upload Relationships Batch
Uploads a batch of relationships to an active sync job. Recommended batch size: 250-500 per call. IMPORTANT: Only works with DIFF sync mode, not PATCH. Each relationship requires _key, _type, _class, _fromEntityKey, and _toEntityKey.

Any other action you can think up

Snowflake

Bulk load data to table from stage Bulk
Bulk load data to table from stage in Snowflake
Delete rows Batch
Delete rows in a table in Snowflake
Export query result
Export query result as a CSV file in Snowflake
Insert row
Insert row in a table in Snowflake
Merge rows
Merge rows from source table to target table in Snowflake
Replicate schema
Replicate table schema in Snowflake
Run custom SQL Batch
Run custom SQL in Snowflake
Run long query using custom SQL
Run long query using custom SQL in Snowflake
Select rows Batch
Select rows in a table in Snowflake
Select rows using custom SQL Batch
Select rows using custom SQL in Snowflake
Replicate rows Batch
Replicate batch of rows to table in Snowflake
Update rows
Update rows in a table in Snowflake
Upload file to internal stage
Upload file to internal stage in Snowflake
Upsert rows Batch
Upsert batch of rows in a table in Snowflake

Any other action you can think up

One platform

Power
Agility
Speed
Innovation