Spanner

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

Prerequisites

To establish a connection between UI Bakery and Spanner, 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 Spanner. Enter your credentials and click Test connection.

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 have a connection between UI Bakery and Spanner, you can access its data, load and send it back. Below are listed the supported action types:

• Load Table;

• Load Row;

• Create Row;

• Update Row;

• Delete Row;

• SQL Query.

1. Add a new action and click Run action to launch it.

2. 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.