Google's cloud warehouse solution provides for very fast querying. Syntasa provides a BQ Connection to connect directly to BigQuery.
After choosing 'Big Query' as the Connection type, the subsequent fields will auto-populate as follows:
- ProjectID - Name of the project where the BQ instance is located.
-
Use Instance Profile
- On (green) - No further information is needed.
- Off (grey)
- Key File Upload - JSON file with project private key.