Google BigQuery OAuth2

In this article

Overview

Use this SnapLogic Account type to connect Snaps to Google BigQuery using OAuth2.

Prerequisites

Valid account setting values, such as hostname or server path, as applicable. These are received from the endpoint that you access using the account.

Limitations and Known Issues

None.

Account Settings

  • Asterisk ( * ): Indicates a mandatory field.

  • Suggestion icon ( ): Indicates a list that is dynamically populated based on the configuration.

  • Expression icon ( ): Indicates the value is an expression (if enabled) or a static value (if disabled). Learn more about Using Expressions in SnapLogic.

  • Add icon ( ): Indicates that you can add fields in the fieldset.

  • Remove icon ( ): Indicates that you can remove fields from the fieldset.

Field Name

Field Type

Description

Field Name

Field Type

Description

Label*

Default Value:  None
ExampleBigQuery OAuth2 Account

String/Expression

Specify a unique label for the account instance.

 

Access token*

Default Value:  None

String

Specify the access token for the application that is auto-generated on authorization. You receive an access token when the account is setup for the endpoint. During setup, the OAuth2 flow is executed and the access token that gets generated is stored in this property. If the access token is refreshed, then the optional refresh token is stored. Get a new access token, if:

  • the access token has expired and no refresh token is defined, or

  • both the access token and the refresh token have expired.

Refresh token

Default Value:  None

String

The refresh token for the application that gets auto-generated on authorization. You receive a refresh token when the account is setup for the endpoint. During setup, the OAuth2 flow is executed and the refresh token that is generated is stored in this property. If the refresh token is already stored, then the access token can be refreshed automatically before it expires.

Access token expiration

Default Value:  None
Example: 16942198634

String

The access token expiration value that gets auto-generated on authorization. The retrieval of the access token expiration is done when setting up the account for the endpoint. There, the OAuth2 flow will be executed and the resulting access token expiration will be stored in this property.

Refers to the access token expiration value for the application. You get the access token expiration when the account is setup for the endpoint. During setup, the OAuth2 flow is executed and the access token expiration that is generated is stored in this property.

OAuth2 Endpoint*

Default valuehttps://accounts.google.com/o/oauth2/auth

String/Expression

Authorization endpoint to authorize the application.

OAuth2 Token*

Default Valuehttps://accounts.google.com/o/oauth2/token

String/Expression

Token endpoint to get the access token.

Auth endpoint config

Provides custom properties for the OAuth2 auth endpoint.

Access Type

Default value: offline

String/Expression

The access type for the token. If you are offline, then it will persist in the account.

Approval Prompt

Default value: force

String/Expression

The approval type for the token.

Default Standard SQL

Default value: Deselected

Checkbox

Select this checkbox to default the dialect in the Query field of the Snaps using this account to Standard SQL.

To override this default setting, use the #legacySQL tag within the Query field of the Snap to treat it as a Legacy SQL query.

Application scope

Default Valuehttps://www.googleapis.com/auth/dfareporting

Examplehttps://www.googleapis.com/auth/cloud-platform

String/Expression

The scope for the applications execution. As an example, the Snap could define that only a read of data by the application should be allowed.

Auto-refresh token

Default value: Deselected

Checkbox

If the auto-refresh token is enabled, the token refreshes automatically. Otherwise, the token might expire and will not be automatically refreshed.

Authorize

Button

When you click Authorize, the OAuth2 authorization flow begins; the account is saved before authorizing.  SnapLogic fetches the Access token, Refresh token, and Access token expiration details and populates these fields with the generated values.

Refresh

Button

Refresh access token. Available after the account has been saved.