# Big Query

UI Bakery allows you to easily connect to Big Query data warehouse with no need for additional layers like APIs or third-party services.

## Configuration

### Prerequisites

To establish a connection between UI Bakery and Big Query, you will first need to [create a private key](https://cloud.google.com/docs/authentication/getting-started).

### Connecting the data source

Once you've obtained the key, you can proceed to connecting the data source.

1. On the **Data sources** page, click **Connect**, and select *Big Query* in the Data sources list.
2. Specify your dataset, service account credentials (your private key), and region qualifier.
3. Click **Test connection** to check whether the data source can be connected, and then click **Connect Datasource** to complete the setup.

UI Bakery will extract the database structure and store column types. This data will be used to suggest the proper [table columns and form field types](https://docs.uibakery.io/concepts/components/work-with-components/field-types-and-types-recognition).

<figure><img src="https://837703843-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FUX6zPRMFFK0yrTghj7cY%2Fuploads%2FxzRXeeqgCrzMamUI2PlL%2FCleanShot%202025-04-10%20at%2016.30.00%402x-min.png?alt=media&#x26;token=3f6bb411-54d2-4fca-a37f-5111c8620cd5" alt=""><figcaption></figcaption></figure>

## Usage

Once you've established the connection between UI Bakery and your Big Query database, you can start interacting with its data.&#x20;

To manage data from Big Query, you can use the [SQL Query](https://docs.uibakery.io/reference/working-with-actions/sql-query) action step.

{% hint style="danger" %}
Note that pre-defined actions, such as *Load Table*, *Create Row*, etc. are NOT supported with this datasource.
{% endhint %}