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 😃
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.