Installation

The Snowflake Integration Jira add-on lets you effortlessly export an issue list from issue searches to Snowflake. Follow the installation instructions below.

Install the Add-On

  1. Log into your Jira instance as an admin.
  2. Click the administration gear in the top right corner and select Apps. The Find new apps screen loads.
  3. Locate Snowflake Integration.
  4. Click Free trial to download and install your add-on.
  5. You're all set! Click Close in the Installed and ready to go dialog.

Configure Snowflake

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.

  1. Log in to Snowflake, click on the Databases icon in the top left, and then click on the Create icon beneath it.
  2. Supply a name for your new database, and click Finish.

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:

  • CREATE TABLE
  • DELETE TABLE
  • INSERT
  • SELECT
  • UPDATE
  • USE SCHEMA

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. The preferred method of identifying your account is the format <orgname>-<account_name>. This information can be found in the menu at the bottom left of Snowflake. Click on the menu and make a note of your organization name and account identifier as shown below:


If you are having trouble finding the necessary identifiers, please refer to the Snowflake documentation.

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.

Configure the 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 Test button to confirm your connection information is correct. If the test fails, return to Snowflake and confirm your user has the necessary permissions. If you have any network policies in place in Snowflake, make sure you have whitelisted the AWS infrastructure IP addresses. If the test passes, 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.