How is your experience with the OutSystems Community?
bigquery-connector
Service icon

BigQuery Connector

Stable version 2.0.0 (Compatible with OutSystems 11)
Uploaded
 on 19 Nov (14 hours ago)
 by 
5.0
 (3 ratings)
bigquery-connector

BigQuery Connector

Compatible with:
Created on OutSystems 11

Version 2.0.0

Stable
Current
See documentation
Uploaded on 14:37 (21 minutes ago) by 
Compatible with:
Version 11
↳11.24.0 or higher
Database:
All
Release notes:

Version 2.0.0 is a major rewrite. Inputs and outputs of the service actions have changed, so consumers must refresh their dependencies and adjust their calls.

Breaking changes

  • Renamed from BigQuery API (module BigQuery_IS) to BigQuery Connector (module BigQueryConnector).
  • All service action inputs now use PascalCase names.
  • Every service action now returns Success, ErrorCode, ErrorMessage, Response, NextPageToken (on list actions), and ResponseJSON.
  • PrivateKey is now a Secret site property, so set it again in each environment.
  • The legacy URL parameters (alt, fields, key, oauth_token, prettyPrint, quotaUser, userIp) were removed.


Fixes

  • Responses are now returned for every method.
  • The request body is now sent for queries and other write operations.
  • Fixed wrong data types in several structures: Dataset.datasetReference, Dataset. labels, and the attributes that were typed as static entity identifiers, which are now Text.
  • Optional parameters are no longer sent when they are empty.


New

  • RunQuery helper: GoogleSQL by default, named parameters, polling until the job completes, and rows returned as JSON objects (RowsJSON).
  • InsertRows helper: stream JSON rows, with optional insert IDs, and get back AllRowsInserted and InsertErrors.
  • New methods: UndeleteDataset, DeleteJob, and row access policies (List, Get, Insert, Update, Delete, BatchDelete).
  • DefaultProjectId site property, used when ProjectId is empty.
  • Google errors are mapped to ErrorCode (the HTTP status) and ErrorMessage instead of raising exceptions. ErrorCode is -1 for local errors.


Improvements

  • The access token is cached for 50 minutes.
  • Each method has its own timeout: 30 s, or 120 s for queries and inserts.
  • Every element is documented: actions, inputs, outputs, structures, attributes, and site properties.
  • The unused structures and static entities were removed.
  • A new demo app (BigQuery Connector Demo) covers the connection test, queries, a data explorer, dataset management, and streaming inserts.
Application Objects:
BigQuery Connector has 43 AOs.

Version 1.0.1

Under Development
Uploaded on 03 March 2021 by 
Compatible with:
Version 11
↳11.9.2 or higher
↳11.7.6 to 11.9.0
↳11.0.606 to 11.0.615
Database:
All
Release notes:

Added more endpoints and structures

Added Demo for API testing

Application Objects:
BigQuery Connector has 57 AOs.

Version 1.0.0

Under Development
Uploaded on 26 February 2021 by 
Compatible with:
Version 11
Database:
All
Application Objects:
BigQuery Connector has 31 AOs.