Connect Snowflake to Jira

Use 12 documented Snowflake triggers to run 24 documented Jira actions.

12 source triggers

24 target actions

Reverse direction supported

Start Free Trial Browse Snowflake integrations

Why Connect Snowflake & Jira?

Start with a Snowflake event

Choose from 12 documented triggers, including New Row, New Query Results, Failed Task in Schema.

Run a Jira action

Send the event into one of 24 documented actions, such as Add Attachment To Issue, Add Comment To Issue, Add Multiple Attachments To Issue.

Map and review the workflow

Choose the fields and conditions for the workflow, then test the result before activation.

Available Triggers & Actions

Snowflake

Triggers (12)

New Row

Emit new event when a row is added to a table

polling

New Query Results

Run a SQL query on a schedule, triggering a workflow for each row of results

polling

Failed Task in Schema

Emit new events when a task fails in a database schema

polling

New Database

Emit new event when a database is created

polling

New Deleted Role

Emit new event when a role is deleted

polling

New Deleted User

Emit new event when a user is deleted

polling

New Role

Emit new event when a role is created

polling

New Schema

Emit new event when a schema is created

polling

New Table

Emit new event when a table is created

polling

New Update Role

Emit new event when a role is updated

polling

New Update User

Emit new event when a user is updated

polling

New Usage Monitor

Emit new event when a query is executed in the specified params

polling

Actions (7)

Execute SQL Query

Execute a custom Snowflake query. See our docs to learn more about working with SQL in Mazaal AI.

Insert Multiple Rows

Insert multiple rows into a table

Insert Single Row

Insert a row into a table

List Database Options

Retrieves available options for the Database field.

List User Name Options

Retrieves available options for the User Name field.

List Warehouse Name Options

Retrieves available options for the Warehouse Name field.

Query SQL Database

Execute a SQL Query. See our docs to learn more about working with SQL in Mazaal AI.

Jira

Triggers (4)

New Event

Emit new event when an event with subscribed event source triggered, See the documentation

webhook

New Issue Created Event (Instant)

Emit new event when an issue is created. Note that Jira supports only one webhook, if more sources are needed please use New Event source and select multiple events.

webhook

New Issue Deleted Event (Instant)

Emit new event when an issue is deleted. Note that Jira supports only one webhook, if more sources are needed please use New Event source and select multiple events.

webhook

New Issue Updated Event (Instant)

Emit new event when an issue is updated. Note that Jira supports only one webhook, if more sources are needed please use New Event source and select multiple events.

webhook

Actions (24)

Add Attachment To Issue

Adds an attachment to an issue. See the documentation

Add Comment To Issue

Adds a new comment to an issue. See the documentation

Add Multiple Attachments To Issue

Adds multiple attachments to an issue. See the documentation

Add Watcher To Issue

Adds a user as a watcher of an issue by passing the account ID of the user, For example, 5b10ac8d82e05b22cc7d4ef5, If no user is specified the calling user is added. See the documentation

Assign Issue

Assigns an issue to a user. See the documentation

Check Issues Against JQL

Checks whether one or more issues would be returned by one or more JQL queries. See the documentation

Count Issues Using JQL

Provide an estimated count of the issues that match the JQL. See the documentation

Create Custom Field Options (Context)

Create a context for custom field options. See the documentation.

Create Future Sprint

Creates a future sprint. See the documentation

Create Issue

Creates an issue or, where the option to create subtasks is enabled in Jira, a subtask. See the documentation

Create Jira Version in Project

Creates a project version. See the documentation

Delete Project

Deletes a project. See the documentation

Get All Projects

Gets metadata on all projects. See the documentation

Get Board

Returns the board for the given board ID. See the documentation

Get Cloud ID

Gets the cloud ID and details of all accessible Jira Cloud sites. See the documentation

Get Current User

Returns the authenticated Jira user's account ID, display name, email, and active status. Call this first when the user says 'my issues', 'assigned to me', or needs their Jira identity. Use the returned accountId with **Search Issues with JQL** (e.g. assignee = '{accountId}') or **Assign Issue**. Requires a Cloud ID to identify the Jira site. See the documentation.

Get Issue

Gets the details for an issue. See the documentation

Get Issue Picker Suggestions

Returns lists of issues matching a query string. See the documentation

Get Issue Types

Gets the available issue types. If a project ID is provided, returns issue types for that project. Otherwise, returns all issue types accessible to the user. See the documentation

Get Sprint

Returns the sprint for a given sprint ID. See the documentation

Get Task

Gets the status of a long-running asynchronous task. See the documentation

Get Transitions

Gets either all transitions or a transition that can be performed by the user on an issue, based on the issue's status. See the documentation

Get User

Gets details of user. See the documentation

Get Users

Gets the details for a list of users. See the documentation