Google AlloyDB
This page walks through how to connect Census with your Google AlloyDB database.
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 support@getcensus.com.
Visit the Destinations page and click + New Destination.
Select AlloyDB from the menu.
Enter the requested database credentials:
🔑 Permissions
To use AlloyDB as a destination, Census requires permission to write to the desired destination tables, as well as read metadata about the table and database structures.
️ Supported Objects and Sync Behaviors
We support syncing data to Tables in AlloyDB, but they must have a uniqueness constraint on a column.
Learn more about all of our sync behaviors in our Syncs documentation.
Contact us if you want Census to support more AlloyDB objects and/or sync behaviors.
Advanced Network Configuration
Census can successfully connect to AlloyDB instances that are using advanced networking controls including region constraints, IP address allow lists, or SSH Tunneling. For more information, see our Network Access Controls documentation.
❗️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 support@getcensus.com or start a conversation with us via the in-app chat.
Last updated