---
title: "Raw SQL Step"
slug: "google-cloud-raw-sql-step"
updated: 2022-08-25T20:07:22Z
published: 2022-08-25T20:07:22Z
canonical: "documentation.decisions.com/google-cloud-raw-sql-step"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://documentation.decisions.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Raw SQL Step

| ## 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 |

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1661458029206.png)

---