How to update specific data in an export

Occasionally it may be necessary to update specific data in an existing export, rather than create a brand new export. Perhaps Jira field configuration has changed, credentials expired, or there were third-party API communication problems. Snowflake for Jira offers several options for updating this data.

Refresh the existing export

This option will clear out your export’s existing work item table in Snowflake and refresh everything there with the latest results of the export’s query, but will not remove any associated data in tables populated by Additional Export option selections. Out of all options presented, this is also likely to take the most amount of time to run.

1. Navigate to the My Snowflake Exports screen (User avatar → My Snowflake Exports) or the Snowflake Exports screen (Gear Icon → Marketplace Apps → Snowflake Exports).

2. Find the export you want to refresh.

3. Select “Update Now” from the Actions menu for the export.

Add to the existing export

This option will keep all your existing data in the export’s table in Snowflake, and only add/refresh data for work items present in the results of a new query. This should be quicker than the first option, depending on the number of work items returned.

1. From the Jira Work Item Navigator view, run a work item search that returns the items you are interested in. This could be the same query that your export currently uses, or it could be more specific. Consider adding an “AND updated >= ‘YYYY-MM-DD’ clause if it helps to further limit the search results.

2. Bring up the Snowflake Export dialog (Apps → Snowflake).

3. Select your existing export from the “Choose export” drop down at the top left of the dialog.

4. Check the “Add to export” checkbox at the top right of the dialog.

5. Click the “Export” button at the bottom right of the dialog.

Create a new export

This option will leave your existing data in the export’s table in Snowflake completely untouched. It is useful in situations where you need to add/update data in tables populated by Additional Export selections, such as worklogs. In some cases this may be more efficient than the first two options, particularly if the export contains a large number of columns. It also avoids any issues with scheduled updates running while also trying to run manual updates. After the export completes, you can delete the export created by this process.

1. From the Jira Work Item Navigator view, run a work item search that returns the items you are interested in. This could be the same query that your export currently uses, or it could be more specific. Consider adding an “AND updated >= ‘YYYY-MM-DD’ clause if it helps to further limit the search results.

2. Bring up the Snowflake Export dialog (Apps → Snowflake).

3. Provide a name for the export.

4. In the Database/Schema drop down (if present), select the same Database/Schema as is used by your existing export.

5. Check the appropriate checkbox in the Additional Exports section, depending on your data needs. Uncheck all other checkboxes in this section.

6. Click the “Export” button at the bottom right of the dialog.

Manually remove work items from Snowflake, and update

This option avoids having to run any queries in Jira, and only pushes work item data to Snowflake that is missing from your existing export, based on its current query. This makes its efficiency similar to the Add to the existing export option described earlier. But since it removes work item data, it may impact downstream consumers of that data until the update completes and all data is repopulated.

1. In Snowflake, run a DELETE command that will remove the affected work items present in the export’s table.

2. After this query completes, in Jira, return to the My Snowflake Exports screen (User avatar → My Snowflake Exports) or the Snowflake Exports screen (Gear Icon → Marketplace Apps → Snowflake Exports).

3. Find the export you want to update.

4. Select “Add Item Data” from the Actions menu for the export.