To create a Google BigQuery data source in Wyn Enterprise, follow these steps. However, it requires a separate driver for its execution which you need to install manually on your system. For more information regarding the driver installation steps, refer to this topic.
On the Resource Portal, navigate to Create (+) > Create Data Source.
Select BigQuery in the data source list on the left or in the icon view on the right.
Fill in the database configuration information for the selected data source.
jdbc:bigquery://MyHost:MyPort;ProjectId=MyProjectId;OAuthType=0;OAuthPvtKeyPath=MyOAuthPvtKeyPath;
jdbc:bigquery://MyHost:MyPort;ProjectId=MyProjectId;OAuthType=2;OAuthAccessToken=MyOAuthAccessToken;OAuthRefreshToken=MyOAuthRefreshToken;OAuthClientId=MyOAuthClientId;OAuthClientSecret=MyOAuthClientSecret;
* Required fields
Verify the Google BigQuery connection by clicking Test Connection. If the data source is available, and the credentials are correct, you receive a notification on successful connection.
Click Create after the connection is successful.
You can view the added data source in the Categories tab of the Resource Portal.