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. 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.

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 Save Configuration button.


Now that setup is complete, continue to the Jira Add-On Configuration page for more information on configuring the add-on.