The RDB via Snapshot Connector can be configured using the Aspire Admin UI. It requires the following entities to be created:

• Credential
• Connection
• Connector
• Seed

Bellow are the examples of how to create the Credential, Connection and the Seed. For the Connector please check this page.

Create Credential

1. On the Aspire Admin UI go to the credentials tab 
2. All existing credential will be list. Click on the new button 
3. Enter the new credential description. 
4. Select Rdb-Snapshot from the Type list.
5. Enter User and Password. Note: The password will be automatically encrypted by Aspire.

Note: we are not going to use this credential, we will use SA instead, creating this because credential is required in connection config) 

Create Connection

1. On the Aspire Admin UI go to the connections tab 
2. All existing connection will be list. Click on the new button 
3. Enter the new connection description. 
4. Select Rdb-Snapshot from the Type list.

5. JDBC Url -  jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId={DATABASE};OAuthServiceAcctEmail=ex-223163-prd-mktplcinteg@prd-223163-mkplace-bd-de4f8262.iam.gserviceaccount.com;OAuthType=0;OAuthPvtKeyPath=/home/dliu/projects/dmp/bigquery-lib/GCP_BQ_SA.json 

   Note - {DATABASE} value will be read from seed "Database name" field. 

6. JDBC Driver Jar  /home/dliu/projects/dmp/baseline/assets/aspire-distribution-archetype-5.0.4-distribution/drivers/GoogleBigQueryJDBC42.jar 

7. Specify Classpath  /home/dliu/projects/dmp/bigquery-lib 

The description of all "connection" fields  can be found here.

Note: The JDBC driver class can be found in attachments - bigquery-lib.zip

Create Connector

For the creation of the Connector object using the Admin UI check this page

Create Seed

1. On the Aspire Admin UI go to the seeds tab 
2. All existing seeds will be list. Click on the new button 
3. Enter the new seed description. 
4. Select Rdb-Snapshot from the Type list.
5. Database name field: The name of the database. It will replace the marker {DATABASE} used in the field jdbcUrl of connection object
6. etc.

The description of all "seed" fields can be found here.