How can I integrate JIRA into Snowflake?

[Gabe Kressel]

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 😃

[Gonchik Tsymzhitov]

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