
Connect to a Custom SQL Query - Tableau
When a custom SQL connection is performing slowly, or produces an error, it is often the result of the custom SQL wrapping that Tableau Desktop performs. For most databases, you can …
Run Initial SQL - Tableau
When connecting to some databases, you can specify an initial SQL command that will run or use a cached value when a connection is made to the database, for example, when you open the …
Connect Tableau Prep to Your Data
If you know exactly the information you need from a database and understand how to write SQL queries, you can use custom SQL queries to connect to data just like you can in Tableau …
Pivot Data from Columns to Rows - Tableau
To optimize your analysis of this data in Tableau, you can use the following custom SQL query to pivot the "Start Time" and "End Time" columns so that their values are in a single column.
Create a Virtual Connection - Tableau
Starting in Tableau Cloud June 2024 and Tableau Server 2024.2, you can approximate the SQL used to connect to a table and use that as a starting point for your own custom SQL.
Create and Use Parameters in Flows - Tableau
You can use this option for parameters used in file names, file paths, table names, custom SQL, and pre and post SQL scripts. Select or enter the parameter value.
Pass-Through Functions (RAWSQL) - Tableau
These RAWSQL pass-through functions can be used to send SQL expressions directly to the database, without first being interpreted by Tableau. If you have custom database functions …
Configure your Data Set - Tableau
Double-click Custom SQL to open the Custom SQL tab where you can enter queries to preselect data and use source-specific operations. After the query retrieves the data set, you can select …
Google BigQuery - Tableau
This article describes how to connect Tableau to Google BigQuery and set up the data source. Note: Some of the features and customizations listed in this article aren't supported in Tableau …
Stored Procedures - Tableau
When you connect to a SAP Sybase ASE, Microsoft SQL Server, or Teradata database with Tableau, you can use a stored procedure to define the connection. For Oracle, you can use a …