Tableau Custom SQL Returns None from Big Query Table

54 Views Asked by At

Has anyone else experienced this issue?

I have a query:

SELECT * FROM `table-in-big-query` AS t1
INNER JOIN ( SELECT unique_Field, MAX(Upload_Datetime) AS latest_Upload_Datetime FROM `table-in-big-query` GROUP BY unique_Field)
AS t2 ON (t1.unique_Field= t2.unique_Field AND t1.Upload_Datetime = t2.latest_Upload_Datetime)

This returns the most recent rows of uploaded data for the unique_Field.

When I run this in On Tableau Online in Tableaus Custom SQL Query I get now Rows in the Response. enter image description here

I also checked it in the Tableau Prep Builder Application just to make sure it wasn't Tableau Online..

I have checked if the connection works by just running

SELECT * from `table-in-big-query`

And it does so I'm not sure where the Mismatch is...

1

There are 1 best solutions below

0
On BEST ANSWER

Thank you to nbk for providing a solution.

I do not have an answer as to why this works but the previous option didn't.

The solution used was:

SELECT * FROM (SELECT *, ROW_NUMBER() OVER(PARTITION BY unique_FieldORDER BY Upload_Datetime DESC)
AS temp_row_number
from `table-in-big-query` )
WHERE temp_row_number = 1