Using Custom SQL Queries
Connecting to a Custom SQL Query
Tableau normally determines what query should be run against CockroachDB in order to build a visualization. However, these queries requres may request data than is needed, or you may need to use features specific to CockroachDB that Tableau does not expose. In these cases you can write a custom SQL query.
- After you have connected to CockroachDB, navigate to the Data Source tab.
- In the left pane, select your Database and Schema.
- Instead of selecting one of the available tables, click New Custom SQL.
- You are then be prompted for your query. Provide any filters aggregates or joins you want here.
- Click OK.
With your custom SQL query provided, proceed to Visualizing Data as if the selection were a normal table.