Create Jira Tickets

Learn how to automatically create Jira tickets from failed dbt™ runs using Bolt webhooks. This guide covers setup, configuration, and best practices for data teams using Jira for pipeline monitoring.

Learn how to automatically monitor your data pipeline and create Jira tickets when dbt™ runs fail in Bolt. This integration helps data teams track and respond to pipeline failures efficiently by connecting Bolt's pipeline monitoring with Jira's issue tracking system.

What You'll Get

When a run fails, Bolt automatically creates a Jira ticket containing:

• Schedule name and workspace

• Various Run details to help you debug, like:

  • Run ID with link to Paradime

  • Execution Start and end time

  • Commands executed Branch information.

Key Benefits for Data Teams

• Automatic Jira ticket creation when dbt™ pipelines fail

• Real-time pipeline monitoring and issue tracking

• Streamlined workflow integration between dbt™ runs and Jira

• Faster response time to data pipeline failures

Prerequisites for Jira Integration

• Existing Bolt schedule

• Admin access to your Jira workspace

• Active Jira project

• Jira API token

Setup Guide

Set up Jira ticket creation for failed runs. Follow the steps below, and watch the interactive tutorial.

Step 1: Gather Your Jira Information

1. Base URL: Get your Jira Base URL (e.g., https://acme.atlassian.net)

2. API Token:

   • Visit https://id.atlassian.com/manage-profile/security/api-tokens

   • Generate an API token

   • Save this token securely

3. User Email:

   • Use the email associated with your API token

   • This must be the email used to create the API token

4. Project Key:

   • Open your Jira project

   • Extract the project key where you want tickets created

Step 2: Configure the Webhook

1. In Bolt, navigate to the lefthand panel and click Templates

2. Click Ticketing and use the "Create Jira tickets" template

3. Enter your:

   • Base URL (example: https://acme.atlassian.net)

   • API Secret (AKA API Token): Visit https://id.atlassian.com/manage-profile/security/api-tokens and generate an API token

   • User Email: the email used to create the API secret

   • Project Key: Extract the JIRA project key where you want to create Jira tickets

4. Click "Connect"

Step 3: Test the Integration

1. Run a Bolt schedule manually that will fail (the webhook only triggers on failed runs).

2. After the run fails, check your Jira project for the new ticket

3. Verify the ticket contains run failure details