I'm joining a Google Cloud Platform table to a SQL Server query based on two fields. In the custom sql for the SQL Server DB, I'm specifying three object IDs, which I verified are present by running the query in SQL Server Management Studio. I also ran a similar query in Google BigQuery and verified the corresponding records are in this data source. But the Tableau report only shows two of the three records. I've tried different combinations of the Cardinality and Referential Integrity options to no avail. Any suggestions?
1 answer
