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 |
---|---|---|
Label* Default Value: None | 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:
|
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 | 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 value: https://accounts.google.com/o/oauth2/auth | String/Expression | Authorization endpoint to authorize the application. |
OAuth2 Token* Default Value: https://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 |
Application scope Default Value: https://www.googleapis.com/auth/dfareporting | 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. |
Related Content
Have feedback? Email documentation@snaplogic.com | Ask a question in the SnapLogic Community
© 2017-2024 SnapLogic, Inc.