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.

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.

Usage

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

To manage data from Big Query, you can use the SQL Query action step.

Note that pre-defined actions, such as Load Table, Create Row, etc. are NOT supported with this datasource.