BigQuery Connector 2.0.0 gives OutSystems 11 apps access to Google BigQuery through the REST API v2, using a Google service account. It ships as a Service module (BigQueryConnector), so consumers reference service actions and don't have to republish when the connector changes.
What it covers:
How a call flows:
You need OutSystems 11, the GoogleAPIToken Forge component (a dependency), and a Google Cloud project with the BigQuery API enabled.
To create the service account:
Set four site properties on the BigQueryConnector module in Service Center, separately for each environment.
Never put the key in code, in literals or in client-side variables. When you rotate the key in Google Cloud, update PrivateKey; the cached token expires within 50 minutes.
Add the service actions you need from BigQueryConnector in Manage Dependencies, call them from server actions, and check Success after every call.
Every service action returns the same outputs:
ProjectId is optional on every action. When it is empty, DefaultProjectId is used.
Use DryRun = True to check the SQL and see TotalBytesProcessed without running it or paying for it.
Streamed rows can be queried within seconds, but they cannot be updated or deleted with DML for up to 30 minutes.
Fill the method's Request structure (for example InsertDataset with a Dataset record), call the action, then read Response or ResponseJSON. Attributes left at their default value are not sent, so a PATCH only changes the fields you set.
The connector has 44 service actions: one per REST method, plus the RunQuery and InsertRows helpers. Each one's description in Service Studio has Google's text, a usage note and the endpoint it wraps.
The actions do not throw on Google errors: check Success and branch on ErrorCode.
Every error is also logged in Service Center, under the BigQueryConnector module.
BigQuery Connector Demo (module BigQueryConnectorDemo, Reactive Web) shows each feature on its own screen. Configure the connector's site properties first, then open Setup.
The Query screen reads public data. The Datasets and Stream rows screens write to your project, so use a test project.
Version 2.0.0 is a breaking release; plan to update every consumer.