Tableau Data Source Refresh

Overview

Paradime provides a convenient way to trigger Data Source refreshes in Tableau, allowing you to keep your visualizations and dashboards up to date with the latest data.

By leveraging the Tableau REST API endpoint for refreshing Data Source, Paradime enables you to automate and schedule the refresh process based right after your dbt™ pipeline completes or in a separate schedule, using the on run completion trigger.

Prerequisites

1. Generate API Credentials

Follow the Tableau integration guide to generate the API credentials

2. Configure Data Source Credentials

To enable Paradime to trigger a data source refresh, ensure that any required credentials are embedded within the extract:

1. Edit the data source in Tableau

2. Click 'Publish'

3. Select 'Embed credentials'

3. Set Environment Variables

Configure the following environment variables in your Bolt Schedules:

• TABLEAU_PERSONAL_ACCESS_TOKEN_NAME

• TABLEAU_PERSONAL_ACCESS_TOKEN_SECRET

• TABLEAU_HOST

• TABLEAU_SITE_NAME

• TABLEAU_TIMEOUT (optional - sets request timeout in seconds, default: 300)

How to Configure Data Source Refresh

When setting up Tableau Data Source Refresh, you can provide one or more Data Source names when setting up the task by adding the names in a separate line.

Alternatively you can provide the Data Source UUID, a string like 9f8e7d6c5b-4a3f-2e1d-0c9b-8a7f6e5d4c. This UUID is used in Tableau’s REST and Metadata APIs to ensure uniqueness even if Data Source names change or duplicate names exist. You can use our CLI to list Data Source and their UUID.

Tableau doesn't let you use the same Personal access token for multiple requests at the same time. So Data Source refreshes have to be executed sequentially not in parallel.

You can monitor your workbook and data source refresh jobs in Paradime Bolt Logs output or directly through the Tableau interface by Navigating in Tableau to the Jobs page.

---

Now, let's learn how to configure the Trigger Types of a Bolt Schedule.