Using data in BigQuery means that the data needs to be uploaded first to Google Storage. BigQuery has an API that can be used to integrate this process into the data analysis. BigQuery is compatible with SQL queries and can be used with Google Apps Script, Google Spreadsheets and other Google services.
BigQuery
BigQuery is a data warehousing product that enables scalable, cost-effective and fast analysis of big data working in conjunction with Google Cloud Storage, as a serverless Software as a Service. The user can manage data using fast SQL-like queries for real-time analysis.