BigQuery Connector for write custom SQL Query to filter Date and join multiple tables
I am trying to write a custom query in BigQuery connector, in order to join multiple tables and set up a date filer, but could find where in PowerQuery to write it. I can't load the seperated tables themselved because they are too big (over 100GB).
LEFT JOIN BigQuery.Table1.Field A = BigQuery.Table.Field 2
WHERE BIGQuery.Table1. Data >="2019-10-01"