Google AlloyDB

🏃‍♀️ Getting Started
This guide shows you how to use Census to connect your AlloyDB database to your data warehouse and create your first sync.
In order for a third party application (like Census) to query your AlloyDB, Google Cloud requires that you set up an Auth proxy as detailed in their documentation. If you have any questions at all setting up this Auth proxy, please reach out to [email protected]. 
Prerequisites
Have your Census account ready. If you need one, create a Free Trial Census account now.
Have your database credentials ready.
Have the proper credentials to access to your data source. See our docs for each supported data source for further information:
​Azure Synapse​
​Databricks​
​Elasticsearch​
​Google BigQuery​
​Google Sheets​
​MySQL​
​Postgres​
​Redshift​
​Rockset​
​Snowflake​
​SQL Server​
Step 1: Connect AlloyDB
Once you're in Census, navigate to Connections​
Click the Add Service button
Select AlloyDB in the list
You'll be prompted to put the following credentials into the Census page:
Hostname
Port
Database Name
Username
Password
After clicking connect, Census will test the connection that was specified.
A Green ✅
, means you are good to go
After the connection is verified, you all tables will be exposed, but please take a look below on some of the specifics. ⬇
​
🗄️ Supported Objects
We support syncing data to Tables in AlloyDB, but they must have a uniqueness constraint on a column. ​
Object Name
Supported
Identifiers
Table
✅
Primary Keys or Columns with Uniqueness Constraints
🔄 Supported Sync Behaviors
Learn more about all of our sync behaviors on our Core Concepts page.
Behaviors
Supported?
Objects?
Update
✅
All
Update or Create
✅
All
​Contact us if you want Census to support more Sync behaviors for AlloyDB.
❗️Common troubleshooting issues
You may be trying to sync to a table that does not have a uniqueness constraint. If possible, you need to add one to be able to sync to it. The syntax to do so is here.
🚑 Need help connecting to Google AlloyDB?
​Contact us via [email protected] or start a conversation with us via the in-app chat.

Offline Conversions

Next - Destinations (app)

Google Analytics

Last modified 18d ago

Copy link

Outline

🏃‍♀️ Getting Started

Prerequisites

Step 1: Connect AlloyDB

🗄️ Supported Objects

🔄 Supported Sync Behaviors

❗️Common troubleshooting issues

🚑 Need help connecting to Google AlloyDB?