---
title: "About AlloyDB prerequisites"
slug: "about-alloydb-prerequisites"
description: "Learn more about what prerequisites must be met when connecting AlloyDB to Supermetrics."
updated: 2025-06-26T12:38:30Z
published: 2025-06-26T12:38:30Z
canonical: "docs.supermetrics.com/about-alloydb-prerequisites"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# About AlloyDB prerequisites

Before you can begin using AlloyDB as a Supermetrics destination, ensure that you’ve met the prerequisites below.

## Prerequisites

### AlloyDB Cluster and PostgreSQL database

You need an existing [cluster for AlloyDB, and a PostgreSQL database](https://cloud.google.com/alloydb) set up inside that cluster.

### Permissions

If you’d prefer to create the destination with a user account, make sure it has permission to:

- Access and ability to create, query, update, rename, drop, insert and delete from objects in a given schema within a Postgres database. [Learn more about access privileges in PostgreSQL](https://www.postgresql.org/docs/current/sql-grant.html).
- Query table and column metadata information in “information_schema.tables” and “information_schema.columns”. [Learn more about PostgreSQL information schema](https://www.postgresql.org/docs/current/information-schema.html).
- For example, your database admin could run the following SQL statements to create a user that should be able to create successful transfers:
  - CREATE user [set user name] WITH CREATEDB PASSWORD [set password]
  - GRANT ALL ON DATABASE [database name] TO [user name]
  - GRANT ALL ON SCHEMA [schema name/s] TO [user name]
  - GRANT ALL ON ALL TABLES IN SCHEMA [schema name/s] TO [user name]
- Note that it’s also possible to take a more granular approach in terms of granting privileges on database objects.

Alternatively, you can use your database admin login credentials to create the destination on the [Supermetrics Hub](https://hub.supermetrics.com/).

### IP allowlisting

If your organization only allows access from “selected networks”, [you need to add the Supermetrics IP addresses to the allowlist in your firewall settings](/v1/docs/about-ip-address-allowlisting-for-data-warehouse-destinations). Don't forget to add your own IP address. [Learn about the permissions you need to modify firewall settings](https://cloud.google.com/alloydb/docs/auth-proxy/connect).

Please note that you need to do the IP allowlisting for the server or server groups where AlloyDB Auth proxy is running in.

## More resources

- [How to configure an AlloyDB destination](/v1/docs/how-to-configure-an-alloydb-destination)
- [How to create a destination](/v1/docs/how-to-connect-to-a-data-warehouse-destination)
- [How to create a transfer](/v1/docs/how-to-create-a-transfer)