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 BigQuery 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 tab to make sure the data is loaded.