UI Bakery allows you to easily connect to a BigQuery data warehouse with no need for additional layers (APIs or 3rd-party services).
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.
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.
2. Check the Result tab to make sure the data is loaded.