The BigQuery modules enable you to monitor tables and completed query jobs, and create, retrieve, update, or delete datasets and tables in your BigQuery account.
Prerequisites
-
A Google account
-
A Google Cloud Platform project created
In order to use BigQuery with Axelor Connect, it is necessary to have a Google account. If you do not have one, you can create a Google account at google.com.
For the list of available endpoints, refer to the BigQuery API Documentation.
-
Log in to your Axelor Connect, add any BigQuery module scenario, and click the Add button next to the Connection field.
-
Optional: In the Connection name field, enter a name for the connection.
-
Click Save.
-
If prompted, log in to your Google account and confirm the access by clicking Allow.
You have successfully connected the app, and can now build scenarios.
After connecting the app, you can perform the following actions:
-
List Datasets
Lists all datasets in the specified project to which the user has been granted the READER dataset role.
-
Get a Dataset
-
Create a Dataset
-
Update a Dataset
-
Delete a Dataset
-
Watch Tables
-
List Tables
-
Get a Table
-
Create a Table
-
Update a Table
-
Delete a Table
-
Watch Rows
-
List Table Data
-
Upload Data (Streaming)
-
Upload a File
-
Watch Query Jobs Completed
-
List Jobs
-
Write Query Jobs Completed
-
List Jobs
-
Write Query
Runs a BigQuery SQL query synchronously and returns query results if the query results if a query completes within a specified timeout.
-
Axelor Connect an API Call