Validate
|
|||||
|
|
||||
Validates a GoogleSQL query for Cloud Dataflow syntax. Will always confirm the given query parses correctly, and if able to look up schema information from DataCatalog, will validate that the query analyzes properly as well
Authorization
To use this building block you will have to grant access to at least one of the following scopes:
- View and manage your data across Google Cloud Platform services
- View your email address
Input
This building block consumes 3 input parameters
| Name | Format | Description |
|---|---|---|
projectId Required |
STRING |
Required. The ID of the Cloud Platform project that the job belongs to |
location Required |
STRING |
The [regional endpoint] (https://cloud.google.com/dataflow/docs/concepts/regional-endpoints) to which to direct the request |
query |
STRING |
The sql query to validate |
= Parameter name
= Format
|
projectId STRING Required Required. The ID of the Cloud Platform project that the job belongs to |
|
location STRING Required The [regional endpoint] (https://cloud.google.com/dataflow/docs/concepts/regional-endpoints) to which to direct the request |
|
query STRING The sql query to validate |
Output
This building block provides 1 output parameters
| Name | Format | Description |
|---|---|---|
errorMessage |
STRING |
Will be empty if validation succeeds |
= Parameter name
= Format
|
errorMessage STRING Will be empty if validation succeeds |