Connect to AlloyDB

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

Contents

Requirements

  • Admin privileges in your Sigma organization.
    For more information, see User account types.
  • An AlloyDB data warehouse, and an account there.

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.

Follow these basic steps to create a connection:

  1. Click the user icon at the top right of your screen. 
    The user icon is usually composed of your initials.
  2. In the drop-down menu, select Add connection.
    Select the Add connection option
  3. The Add new connections page appears.
    The connections page lists all supported database types, as icons
  1. In the Connection details, specify these:
    Name
    Specify the Name of the new connection. Sigma displays this name in the connection list.
    Here, we use AlloyDB connection.
    Type
    Select the tile that represents the data warehouse you use.
    Here, click the AlloyDB tile.
  2. In the Connection Credentials section, specify the following:
    Host
    The path to your database. This can be a URL, or an IP address.
    Enter your cluster's Endpoint URL. Sigma connects from IPs 104.197.169.18, and 104.197.193.23.
    Port
    The port that Sigma uses to connect to the host.
    User
    The username, or account, for connecting to AlloyDB.
    For example, test.
    Password
    Enter the password that corresponds to the User on the AlloyDB account.
    Database
    The name of the database you plan to query.
    Enable TLS
    Optional.
    This switch enables or disables TLS encryption on your connection.
    Enabled by default.
    SSH Tunnel
    Optional.
    This switch enables the SSH protocol for secure remote login. For details, see Connect through SSH.
    Disabled by default.
    Connection credentials for MySQL
  3. In the Connection Features section, specify the following:
    Connection timeout
    The time before timeout (or cancellation), in seconds, that Sigma waits for the query to return results.
    Default is 120, or 2 minutes.
    Connection queue size
    The number of concurrent interactive queues that Sigma establishes for the connection.
    Default is 8.
    Use friendly names
    This switch makes column names from the data source more readable.
    For example, a database column ORDER_NUMBER appears as Order Number.
    On by default.
    Connection features for MySQL
  4. In the Write Access section, decide if you require write access.
    See Set up write access.
    Enable write access
    Necessary for one of the following feature:
    Off by default.
    Write access for the connection
  5. After you specify all the parameters of the connection, click Create.
    Create the connection
  6. After you successfully create your connection, Sigma displays it on the screen.
    New connection created successfully
  7. To verify your connection, click Browse Connection, and then explore the visible databases and tables.
    Explore dbs and tables
  8. Click Add Permission to grant data access for users in your organization.
    See Data permissions.
    alt
  9. The new connection also appears in the list of connections you have in your account.

Locate your AlloyDB cluster credentials

  1. In the Google Cloud console, navigate to the Clusters page.
  2. Click the cluster that you plan to connect to Sigma.
  3. A cluster page appears.
    It lists the required credentials for connecting to Sigma.

Related resources

Was this page helpful?
Yes No