Connect to AlloyDB (Beta)

This document explains how to connect your AlloyDB Cluster to Sigma Computing. 

Summary of Content

Requirements
Connect to your AlloyDB Cluster
Locate your AlloyDB Cluster Credentials
Related Resources

 

Requirements

Connect to your AlloyDB Cluster

Note: If your AlloyDB instance is on a VPC, you will need to take additional steps. For more information, see Configure VPC Service Controls.

  1. Open your Admin Portal by selecting Administration in the user menu at the top right of your screen.
  2. Select the Connections page from the left-hand panel.

    company apps
  3. Click the Create Connection button.
  4. Name your connection.
  5. Select AlloyDB under warehouse Type.
    Once selected, you're prompted to define your Connection Credentials.

    company apps

  6. Enter your cluster Endpoint URL In the Host field.
    Note: Sigma will connect from 44.229.241.60, 104.197.169.18, 104.197.193.23, and 54.188.54.135.
  7. Enter your cluster’s port number in the Port field.
  8. Enter your AlloyDB username in the User field. 
  9. Enter your AlloyDB password in the Password field.
  10. Enter your cluster’s database name in the Database field.
  11. [optional] Enable TLS encryption on your connection. 
  12. [optional] Connect to your instance via SSH Tunnel
    If you enable the SSH Tunnel, you're prompted to enter the Tunnel host and Tunnel port.
    Learn more about configuring a SSH Tunnel. 
    company apps
  13. [optional] Under Connection Features, you can set a connection timeout and/or enable write access.
  14. Click Create in the top right to create your configuration.

Locate your AlloyDB Cluster Credentials

  1. In the Google Cloud console, go to the Clusters page.
  2. Click on the cluster you would like to connect to Sigma.
    This opens the cluster page where you locate the required credentials to connect to Sigma.

Related Resources

Connect via SSH