Google Data Catalog Connection
See the Connector Marketplace topic. Please request your administrator to start a trial or subscribe to the Premium Google Data Catalog connector.
Google Data Catalog is a service that helps organizations discover, manage, and understand their data assets across different platforms and environments.
This topic describes how to authenticate to Google Data Catalog and configure any necessary connection properties in the Google Data Catalog connection connector.
Prerequisites
Enable the Data Catalog API
Follow these steps to enable the Data Catalog API:
Navigate to the Google Cloud Console.
Select Library from the left-hand navigation menu. This opens the Library page.
In the search field, enter “Google Cloud Data Catalog API” and select Google Cloud Data Catalog API from the search results.
On the Google Cloud Data Catalog API page, click ENABLE.
Connection Configuration
Each connection property available in the Google Data Catalog connector is explained below.
Connection Name
The name of the connection to be created should be provided. This is the name that will display on the list of available connections.
Auth Scheme
The type of authentication to use when connecting to Google Data Catalog.
Possible Values
OAuth2
Set this to use OAuth2 authentication.
If OAuth2 is selected, additional configuration parameters will get listed.
Client ID
The client ID assigned when you register your application with an OAuth authorization server.
Client Secret
The client secret assigned when you register your application with an OAuth authorization server.
Refresh Token
The OAuth refresh token for the corresponding OAuth access token.
Service Account
Set this to use Service Account as authentication.
If Service Account is selected, additional configuration parameters will get listed.
Certificate Type
The type of key store containing the Service Account Certificate.
Possible Values
JSON
Set this to use a certificate with type as JSON, for authentication.
If JSON is selected, proceed by uploading the keystore file.
PFX
Set this to use a certificate with type as P12, for authentication.
If PFX is selected, additional configuration parameters will get listed.
Certificate Issuer: Set this to the email address of the service account. This address will usually include the domain iam.gserviceaccount.com.
Certificate Password: Set this to the .pfx file password. In most cases you must provide this since Google encrypts PFX certificates.
Upload File
Upload Service Account Certificate. Use JSON file if Certificate Type is JSON, else use PFX(P12).
Organization ID
The ID associated with the Google Cloud Platform organization resource to connect to.
Find this by navigating to the cloud console.
Click the project selection drop-down, and select your organization from the list.
Then, click More -> Settings.
The organization ID is displayed on this page.
Project ID
The ID associated with the Google Cloud Platform project resource you would like to connect to.
Find this by navigating to the cloud console dashboard and selecting your project from the Select from drop-down.
The project ID will be present in the Project info card.
Set this to a comma-separated values for more than one Project (Project1, Project2).
After entering all the details, click on the TEST button.
If the connection service identification and authentication details are provided correctly, a success message stating “connection available” is generated.
Click on the CREATE button to save the changes.
If the details are incorrect or the server is down, you will get a message “Connection unavailable”.
If you have any feedback on Gathr documentation, please email us!