...
- User should provide the correct project id which he has access to.
- User should provide the SQL query against a dataset inside his project.
- User should provide the Json Key File of the project.
- User should provide the temporary google cloud storage bucket to store the intermediate query result.
- User should provide the fully qualified input table in BigQuery. If import query is not provided, this table will be downloaded to
temporary Google Cloud Storage directory and finally to the CDAP source. If import query is given, this table will be a intermediate
storage to cache the query result and then downloaded to the temporary directory in Google Cloud Storage before going to CDAP source. - The temporary Google Cloud Storage directory should be deleted manually to avoid unnecessary charge from Google.
Example
Following is a are two simple example examples showing how BigQuery Source would work.
...
project Id: vernal-seasdf-123456
dataset name: baby_names
table name: names_2014
| name | count |
|---|---|
| Emma | 100 |
| Oscar | 334 |
| Peter | 223 |
| Jay | 1123 |
| Nicolas | 764 |
...