Content in Tableau Community Forums

How to stop Tabelau to loading metadata while executing custom query

tableaucommunity@tableau.com — Wed, 15 Nov 2017 18:11:21 GMT

By default Tableau is running following queries for Custom Query

[Q 1]

SELECT

FROM

(

SELECT

FROM

test

) TableauSQL LIMIT 1

[Q 2]

SELECT

FROM

TableauSQL LIMIT 1

Here what is the "TableauSQL"? Is it temp created table. if so i have customized my Tableau to stop creating Temp tables on fly as following

</customizations>

Is there any changes I need to do or add something in the above list?

Custom Query with JOIN problem

tableaucommunity@tableau.com — Fri, 01 Mar 2013 20:10:31 GMT

Multiple Tables selection problem:

My database supports the keyword like "LEFT OUTER JOIN" but the Tableau support or prepares the query with keyword like "LEFT JOIN"

So how can I make or customize the Tableau to make above changes.

How to stop Tabelau not to executing unwanted custom query

tableaucommunity@tableau.com — Fri, 01 Mar 2013 20:06:23 GMT

Hi ,

By default Tableau is running following queries for Custom Query

[Q 1]

SELECT * FROM (

SELECT * FROM test

) TableauSQL LIMIT 1

[Q 2]

SELECT * FROM TableauSQL LIMIT 1

Why I am getting the table name as “TableauSQL” in the above query instead of my table name.

</customizations>

Is there any changes I need to do or add something in the above list?

Max size of string limit in Tableau

tableaucommunity@tableau.com — Wed, 27 Feb 2013 01:05:25 GMT

What is the Max size of string limit in Tableau?

Please help me out

Tableau Table values in as NULL

tableaucommunity@tableau.com — Thu, 21 Feb 2013 22:48:01 GMT

Tableau Table values in as NULL

When I Tableau execute following query on my database

[1]

SELECT

test100.name AS none_name_nk

FROM

test100

GROUP BY

test100.name

[2]

SELECT

1 AS Number_of_Records

,test100.id AS id

,test100.name AS name

FROM

test100

Above quires ran successfully, but when I go through "View Data ->Underlying Data" not able to see values in the Tableau view(Please refer attached screenshot and work book also )

Only I can see is the count (as 1).

Please help me out.

Tableau Query ALIAS Problem

tableaucommunity@tableau.com — Wed, 20 Feb 2013 06:51:15 GMT

SELECT

test100.name AS none_name_nk

FROM

test100

GROUP BY

test100.name

In the above query I wanted to remove the " none_name_nk" .

But i tried with the .tdc with

Eventhough I am getting the above query with ALIAS AS column name as "test100.name AS none_name_nk"

Here actually I wanted to remove the ALIAS string "AS none_name_nk" in the query.

Please do needful to solve above problem.