Raw SQL Step
- 25 Aug 2022
- 1 Minute to read
- Print
- DarkLight
Raw SQL Step
- Updated on 25 Aug 2022
- 1 Minute to read
- Print
- DarkLight
Article Summary
Share feedback
Thanks for sharing your feedback!
Step Details | |
| Introduced in Version | 3.0.0 |
| Last Modified in Version | 8.0.0 |
| Location | Integration > Google Cloud > BigQuery |
The Raw SQL Query step found under Integration > Google Cloud > BigQuery provides a way for Decisions to utilize BigQuery's ODBC to establish a connection to a data warehouse.
Using this step, the data warehouse can be queried and returned as a list of DynamicDataRows in Decisions. To successfully use this step, a Google Cloud service account must be configured.
Properties
Settings
| Property | Description | Data Type |
|---|---|---|
| JSON Credentials | This setting represents the current service account credentials that is used to authenticate access to Google Cloud. Multiple credentials can be configured in the settings for the module. | String |
Inputs
| Property | Description | Data Type |
|---|---|---|
| Project ID | The Project ID is a string used to identify the project as it appears in Google Cloud. This is used to specify which project Decisions will attempt to use within the cloud | String |
| Query | Tthe SQL statement that will be used to query the data from the data warehouse. | String |
| Use Legacy SQL | If enabled, the query will be sent as Standard SQL syntax instead of using Google's custom dialect. | Boolean |
Outputs
| Property | Description | Data Type |
|---|---|---|
| Query Results | The results returned from the query. | List of DynamicDataRow |
Was this article helpful?
