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