How can I integrate JIRA into Snowflake?

Gabe Kressel April 21, 2021

So I basically want to create an automation where newly created JIRA issues are listed in Snowflake, in some format. I've read something about using AWS lambda and AWS S3 bucket + kinesis and firehose, but is there any other way? An easier way? I would also like to know how to exactly do this with the AWS tools.

 

PS. I'm quite new at this stuff 😃

3 answers

0 votes
Jeffrey Wolfe October 30, 2024

Hi,

The simplest solution for you will be to use third-party tools, like Skyvia (https://skyvia.com/data-integration/replicate-jira-to-snowflake) or similar ETL tools. They allow you to automate data loading between Jira and Snowflake easily without a need to manage complex AWS components or write custom scripts.

Hope it helps

0 votes
MobilityStream
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 26, 2024

HI @Gabe Kressel ,

If you are looking for an easy way to connect Jira with Snowflake, I would also recommend to look at our Atlassian Marketplace app: https://marketplace.atlassian.com/apps/1227353/snowflake-for-jira

You will be up and running in minutes and can pick which data to load such as issues, versions, projects, users, components, etc. Unlike other solutions it won't just query each API endpoint and create a messy set of tables that require modification but produces a relatively clean table structure. Also, it is optimized for Snowflake to reduces credit usage.

Kind regards,

The Mobility Team

0 votes
Gonchik Tsymzhitov
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 25, 2021

Hi @Gabe Kressel , 

so I see a few ways:

1. Own Script to fetching and loading (ETL)

 

2. middleware https://jira.tosnowflake.com/

 

Where you can find a good solution for the fetching via exist solution on marketplace to make fetching work

Suggest an answer

Log in or Sign up to answer