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.



All

arrow_forward BigQuery Query To View

Create a BigQuery view.



lock_openGet Access listGit Hub sourcePython menu_bookColab airAirflow



Instructions

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.

Details

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."
                    }
                }
            }
        }
    }
]


Run This Workflow In Minutes On Google Cloud

Everything from a quick Google Cloud UI to reference developer code for your team in one GitHub repository.

Deployment Stepslaunch Developer Guidebuild UI How Tolaptop