The Snowflake Integration Jira add-on lets you effortlessly export an issue list from issue searches to Snowflake. Follow the installation instructions below.
To export Jira issue data to Snowflake, you will need a database in Snowflake, user credentials to access that database, and your Snowflake account identifier.
If you do not already have a database for exports, create one in Snowflake by following the steps below.
Next, make sure that your new database as a "PUBLIC" schema, and make sure that you have the user credentials necessary to access and modify this database. The user will need to have the following privileges:
Please see the Snowflake Access Control documentation for additional information on these privileges and how to apply them to a user in your instance.
Finally, you will need your Snowflake account identifier. This information can be found in the user drop down at the top right of Snowflake. Click on your username and make a note of the account identifier as shown below:
With a database, schema, user credentials, and account identifier, you're ready to move on to the next steps and configure the Jira add-on.
To use the integration, you have to configure the add-on.
In Jira, click on the administration gear in the top right corner and select Apps.
Click Manage Apps on the left side and search for the Snowflake Integration add-on in the list of installed apps. Then click on the Configure button.
Now you can enter the credentials and account information from the Configure Snowflake steps.When you are finished, click the Save Configuration button.
Now that setup is complete, continue to the Jira Add-On Configuration page for more information on configuring the add-on.