I am not a Tableau developer. But I am working as a data engineer for a Dashboard project.
Can you give me any idea about the following case?
Our dashboard table is the quite big to work with extract mode. one day partition of the table includes 400M row and it keeps 30 days partitions.
For this reason we are using live connection. We passed the filter with the params to the custom SQL like below query.
SELECT GSM_NO, CELL,LAC,MEASURE,PDATE FROM BD_TABLE WHERE PDATE>= < PARAM_START> AND PDATE>= < PARAM_END> AND GSM IN (<GSM PARAM>)
If the <GSM PARAM> takes the multiple values, it will work. but as far as I understand it is not supported by Tableau.
What is the alternative solution of this issue?
If we remove the GSM filter in custom SQL, Tableau tries to extract all data in related partitions. Is it possible to open the dashboard with default gsm filters not use params, before the extract all data?
You can add data source filter (Upper Right Corner) on Data Source page if your Gsm filter is static.