Big Query

UI Bakery allows you to easily connect to a BigQuery data warehouse with no need for additional layers (APIs or 3rd-party services).

Prerequisites

To establish a connection between UI Bakery and BigQuery, you will need to create a private key upon the connection configuration.

Configuration

Once you have the key, go to the Data sources page –> Connect –> Choose BigQuery. Enter your credentials and click Test connection.

Adding as a Data source

When the connection is successful, click Connect Data source. 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 establish the connection, you can interact with the data.

1. Add a new action - SQL query. Specify your query and click Run action to launch it.

Note that pre-defined actions, such as Load Table, Create Row, etc. are not supported for BigQuery datasource.

2. Check the Result section to make sure the data is loaded.

3. ​Transform or map your data.

4. ​Add a Component to display it.

SQL query