Tony indeed we can directly connect to BigQuery.
You can select any BigQuery table as the source of your connection and send its data to any destination, be it a Google Sheet, Excel, CSV or other kind of file.
The 1000 updates is the quota limit of our current Professional plan.
Meaning you can refresh your BigQuery connection 1000 times before you have hit your quota limit for the current month.