Tableau

Tableau is a powerful and user-friendly data visualization tool that allows users to create interactive and shareable dashboards from various data sources.

Using Weld to build a data destination ensures that all your company's systems data is centralized, transformed, and ready for analysis within Tableau.

How to connect to Weld

Connect your data in Weld to Tableau through a direct connection between your destination and Tableau

Connect BigQuery

Tableau Recommendation

Set up a custom OAuth Client to use your company's IT policies

You can fully control your OAuth configuration according to your own IT policies with a custom OAuth client. The option to use your own OAuth client frees you from being tied to Tableau release cycles and Tableau’s OAuth client rotation schedule. For information on how to configure your own OAuth client see, Configure Custom OAuth for a site.

To use service account credentials for a new Google BigQuery data source, the connection must be created in Tableau Desktop.

Launch Tableau Desktop to begin the process.

  1. In Tableau Desktop, click on the Connect to Data button or navigate to the Connect tab.
  2. In the To a Server section, select Google BigQuery from the list of available data sources.
  3. Authenticate with Google: Tableau will prompt you to authenticate with your Google account to access your BigQuery project. Follow the authentication process and grant the necessary permissions.
  4. Select your project and dataset: After authentication, you will see a list of your BigQuery projects and datasets. Choose the appropriate project and dataset that contains the data you want to connect to Tableau.
  5. Choose the tables or views: Select the tables or views you want to import into Tableau. You can either import entire tables or write custom SQL queries to retrieve specific data.
  6. Customizations and options: Tableau offers various options to customize the connection and data import process. You can specify filters, aggregations, and other settings as per your requirements.
  7. Analyze and visualize: After the data is is connected, you can start analyzing and visualizing it using Tableau's features and tools. Explore the data, create dashboards, and design visualizations as needed.

That's it! You have successfully connected your BigQuery database to Tableau and can now analyze and visualize your data using Tableau's powerful capabilities.

Please refer to Tableau Documentation for further information

Connect BigQuery (Service Account)

You can also choose to use a Service Account to connect BigQuery in PowerBI. Using a service account for authentication provides enhanced security and automation capabilities, eliminating the need for manual user intervention and frequent re-authentication that comes with OAuth.

To connect a using a Service Account, ensure you have your service account JSON file ready.

  1. Open Tableau Desktop: Launch the Tableau Desktop application on your computer.
  2. Go to Data Source: Navigate to the Data menu and choose Connect to Data.
  3. Select Google BigQuery: In the list of databases and connectors, locate and click on Google BigQuery.
  4. Enter Project ID: You'll be prompted for your Google BigQuery project ID. This ID can be located in your Google Cloud Console.
  5. Choose Authentication Method: In the authentication window, select the Service Account option.
  6. Upload JSON Key: An input field labeled Key File Path will appear. Browse to the location of your service account JSON file on your computer and select it.
  7. Initiate Connection: After selecting the JSON file, click the Connect button to initiate the connection to your Google BigQuery dataset.
  8. Select Dataset: Tableau will display a list of available datasets from your Google BigQuery account. Choose the desired dataset or table you wish to analyze.
  9. Load Data: Drag your chosen dataset or table to the data pane to begin your analysis in Tableau.

Connect Snowflake

Driver required

This connector requires a driver to talk to the database. You might already have the required driver installed on your computer. If the driver is not installed on your computer, Tableau displays a message in the connection dialog box with a link to the Driver Download page where you can find driver links and installation instructions.

Note: To support using OAuth with Snowflake, you must install the latest ODBC driver from Snowflake.

Launch Tableau Desktop to begin the process.

  1. In Tableau Desktop, click on the Connect to Data button or navigate to the Connect tab.
  2. Choose Snowflake: In the To a Server section, select Snowflake from the list of available data sources.
  3. Enter Snowflake server details: Tableau will prompt you to enter the server details for your Snowflake database. Fill in the following information:
  4. Server: Enter the server name or URL of your Snowflake instance.
  • Username and Password: Provide your Snowflake credentials.
  • Account: Specify the Snowflake account name.
  • Choose authentication method: Select the authentication method based on your Snowflake configuration. Options include username and password, SSO (Single Sign-On), and OAuth.
  1. Specify additional connection details: Depending on your Snowflake setup, you may need to provide additional connection details such as a database, schema, or warehouse. Fill in the necessary information as per your Snowflake configuration.

Once the Snowflake connection is established, you can start analyzing and visualizing your data using Tableau's features and tools. Explore the data, create dashboards, and design visualizations as needed.

Please refer to Tableau Documentation for more details

Was this page helpful?