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 Run

Run query on a project.



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...
For non legacy use: SELECT * `project.datset.table` WHERE...

Details

Open Source YES
Age Aug. 14, 2017 (5 years, 4 months)
Authors terwilleger@google.com
Shedule Days Configured by user.
Shedule Hours Configured by user.
[
    {
        "bigquery": {
            "auth": {
                "field": {
                    "name": "auth_write",
                    "kind": "authentication",
                    "order": 1,
                    "default": "service",
                    "description": "Credentials used for writing data."
                }
            },
            "run": {
                "query": {
                    "field": {
                        "name": "query",
                        "kind": "text",
                        "order": 1,
                        "default": "",
                        "description": "SQL with newlines and all."
                    }
                },
                "legacy": {
                    "field": {
                        "name": "legacy",
                        "kind": "boolean",
                        "order": 2,
                        "default": true,
                        "description": "Query type must match table and query format."
                    }
                }
            }
        }
    }
]


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