The StarThinker project will no longer receive new solution contributions from the Google team.
Please read the full StarThinker Open Source Support Ends At Google article for more details.
Create a BigQuery view.
| Specify a single query and choose legacy or standard mode. |
| For PLX use: SELECT * FROM [plx.google:FULL_TABLE_NAME.all] WHERE... |
| If the view exists, it is unchanged, delete it manually to re-create. |
| Open Source | YES |
| Age | Aug. 14, 2017 (5 years, 4 months) |
| Authors | kenjora@google.com |
| Shedule Days | Configured by user. |
| Shedule Hours | Configured by user. |
[
{
"bigquery": {
"auth": {
"field": {
"name": "auth_read",
"kind": "authentication",
"order": 1,
"default": "user",
"description": "Credentials used for reading data."
}
},
"from": {
"query": {
"field": {
"name": "query",
"kind": "text",
"order": 1,
"default": "",
"description": "SQL with newlines and all."
}
},
"legacy": {
"field": {
"name": "legacy",
"kind": "boolean",
"order": 4,
"default": true,
"description": "Query type must match source tables."
}
}
},
"to": {
"dataset": {
"field": {
"name": "dataset",
"kind": "string",
"order": 2,
"default": "",
"description": "Existing BigQuery dataset."
}
},
"view": {
"field": {
"name": "view",
"kind": "string",
"order": 3,
"default": "",
"description": "View to create from this query."
}
}
}
}
}
]Everything from a quick Google Cloud UI to reference developer code for your team in one GitHub repository.