About 9,460 results
Open links in new tab
  1. 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 …

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

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

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

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

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

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

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

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

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