Help Desk

Submit a ticket My Tickets
Welcome
Login

Google BigQuery BizApp


Premium BizApp

With the OneCloud Google BigQuery BizApp, you can natively integrate with the Google BigQuery system. Combining the ability to perform Google BigQuery database operations across other applications including Tableau and Power BI and performance management applications such as Anaplan, IBM Planning Analytics, Host Analytics, and Oracle EPM, allows OneCloud customers to easily and bi-directionally share their data stored in Google BigQuery with other applications.

For documentation on all available commands, see the Google BigQuery Command Reference

Need a specialized Google BigQuery Command?

If there are specific Google BigQuery  operations that your company is looking to perform support@onecloud.io to discuss the requirements and the possibility to incorporate the capability into OneCloud,

Connection Setup

To enable OneCloud to interact with a relational system, you’ll need to navigate to the connection manager to create a connection. From here, choose Google BigQuery from the service drop-down and select the appropriate Runner. 

InputTypeDetailNotes
UsernameText FieldYour BigQuery Project ID
The Project ID can be found by clicking the Project selector in the top bar of the BigQuery UI.
UsernameText FieldYour service account credentials JSON file
This file gets generated when creating your service account. See the following link for more details: https://cloud.google.com/iam/docs/creating-managing-service-accounts

Connection Example

The following is an example of a working connection. Please substitute your own values.

O
OneCloud is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.