Google Cloud BigQuery

Imports data from Google Cloud BigQuery

To access Google Cloud Platform, you need a credential file. See Google Application Authentication Documentation. And set the GOOGLE_APPLICATION_CREDENTIALS env in Ananas workspace.yml file. See Google Dataflow Engine

What it does

Connect to and import data from the table in Google Cloud BigQuery.

Google Cloud BigQuery is a serverless, highly-scalable, and cost-effective cloud data warehouse with an in-memory BI Engine and machine learning built in.

Settings

• Project Id

  The google cloud project id

• Dataset

  The dataset in Google BigQuery

• Table Name

  The table where you wants to read data from

• BigQuery SQL

  you can use an BigQuery SQL query to filter the data that you want to work on. By default, all data will be processed (SELECT *).

Tips

• Using the advanced SQL query settings to filter the data can reduce the processing time.

• You don't need to replace [TABLE] in the BigQuery SQL field, Ananas Analytics Desktop will inject the right value according to your settings.