Google Cloud BigQuery policy

A Google Cloud BigQuery policy contains the connection details that are used by a Google Cloud BigQuery Request node when you connect it to Google Cloud BigQuery.

You can use a Google Cloud BigQuery Request node in a message flow to connect IBM® App Connect Enterprise to Google Cloud BigQuery and issue requests to perform actions on objects such as data sets, jobs, tables, and views. The Google Cloud BigQuery policy controls, at run time, access to the Google Cloud BigQuery application.

The Google Cloud BigQuery policy is created when you configure a connection between a Google Cloud BigQuery Request node and Google Cloud BigQuery by using the Connector Discovery wizard. During the process of discovery, account credentials are stored in the vault and connection details are stored in a policy. The policy is created with a type of Google Cloud BigQuery, and the name of the policy is returned to the node and specified in the Connection tab, in the format {policyProjectName}:policyName.

You can also create, update, or delete a Google Cloud BigQuery policy by using the Manage Discovery Connector Policies and Credentials wizard, which you can access by right-clicking the policy project in the IBM App Connect Enterprise Toolkit and then clicking New > Discovery Connector policies and credentials.

You must deploy this policy before message flows that use the policy are started. If you redeploy a Google Cloud BigQuery policy, all message flows that are using the policy are stopped and restarted.

For more information about using Google Cloud BigQuery policies, see Using Google Cloud BigQuery with IBM App Connect Enterprise.

Table 1. Properties of the Google Cloud BigQuery policy
Property	Property name in .policyxml file	Description of properties
Google Cloud BigQuery Application Type	applicationType	This property is reserved for future use and must be set to the value `online`.
Google Cloud BigQuery Application Version	applicationVersion	This property is reserved for future use and must be set to the value `v1`.
Google Cloud BigQuery Authentication method	authenticationMethod	This property specifies the type of authentication that is used for the connection between IBM App Connect Enterprise and Google Cloud BigQuery. This property is reserved for future use and must be set to `BASIC`.
Project ID	projectId	Your Google Cloud BigQuery Project ID.
Data set ID	datasetId	The ID (schema name) of the data set containing the tables and views that you want to work with in your Google Cloud BigQuery project. To work with tables or views from another data set, you need to create a different account by using that specific data set ID.
Credential Name	credentialName	The specified credential can be defined during connector discovery and stored in the vault. Alternatively, you can specify an existing credential that was configured by using the mqsicredentials command or the server.conf.yaml file, or loaded through an external credential provider.