Azure Private Link Connections

This document explains how to connect Sigma to your data warehouse that's hosted on Azure using Azure's Private Link.Β Β 

πŸ“˜

See Sigma's Azure Private Link lab for more information on how to establish a secure connection between Sigma and an Azure data warehouse.

Requirements

  • A Sigma organization running on Azure.
  • Admin privileges in your Sigma organization; see User account types.
  • Snowflake, Databricks, or PostgreSQL Admin, depending on the data warehouse
  • Azure AdminΒ 

IntroductionΒ 

Sigma organizations running on Azure can securely connect to their data using Azure's Private Link, which allows Sigma to access the data warehouse hosted on Azure via a private endpoint in the virtual network. This not only enhances security during data transit but also improves performance by reducing network latency. With Private Link, Sigma connects to the data warehouse using private IP addresses, ensuring traffic never leaves the Microsoft network and data remains secure without exposure to the internet.Β 

To utilize Private Link, create a private endpoint in your virtual network that maps to the data warehouse, assign it a private IP address, and connect to the warehouse using this address.

Sigma supports connections to the following data warehouses on Azure:

  • Snowflake
  • Databricks
  • PostgreSQL

Create Private Link Connection for Your Data Warehouse

Follow the steps below to create a Private Link connection to your data warehouse hosted in Azure.

πŸ“˜

To initiate this process, the first step for all data warehouses is to retrieve the required information and send to your account manager.

SnowflakeΒ 

Provide Snowflake Info to Sigma

Follow the steps below to provide Sigma with the requisite information to create a Private Link for your organization.Β Β 

πŸ“˜

Your Snowflake account must be Business Critical tier to use Private Link.

  1. In the Snowflake SQL console, execute the following command:

    select system$get_privatelink_config();

    company apps

  2. Below is the output from the SQL query. In the example above, the output is highlighted in blue.Β 

    {"regionless-snowsight-privatelink-url":"app-br67048-sigma\_azure\_us\_east\_2.privatelink.snowflakecomputing.com", "privatelink-account-name":"os99982.east-us-2.privatelink", "snowsight-privatelink-url":"app.east-us-2.privatelink.snowflakecomputing.com", "privatelink-account-url":"os99982.east-us-2.privatelink.snowflakecomputing.com", "privatelink-pls-id":"sf-pvlinksvc-azeastus2.cf82bce2-bw2d-4dw2-92ee-3dw2fb04d191.eastus2.azure.privatelinkservice", "regionless-privatelink-account-url":"br67048-sigma\_azure\_us\_east\_2.snowflakecomputing.com", "privatelink\_ocsp-url":"ocsp.os99982.east-us-2.privatelink.snowflakecomputing.com", "privatelink-connection-urls":"\[\]"}

    In the output field, copy the values for privatelink-pls-id and private-account-url. In the example above, the values are coded red.

    In the example above, private-pls-id is

    sf-pvlinksvc-azeastus2.cf82bce2-bw2d-4dw2-92ee-3dw2fb04d191.eastus2.azure.privatelinkservice

    and private-account-url is

    os99982.east-us-2.privatelink.snowflakecomputing.com

  3. Send these two values to your Sigma account manager.

  4. Sigma will create a Private Link and alert you when the link is active.

    πŸ“˜

    You can't configure the connection until Sigma creates the Private Link.

Configure Snowflake Connection

Follow the steps below to configure your Sigma Snowflake connection to use Private Link.Β 

  1. Once the private link is active, in Sigma go to Admin > Connections > Snowflake.Β 

  2. Click Create to create a Snowflake connection.Β 

  3. In the Account field, enter the three parts of the account URL in this format: <account>.<region_id>.privatelinkFor example, if the account URL is

    test123.west-us-2.privatelink.snowflakecomputing.com

    Β Then the Account field will be test123.west-us-2.privatelinkΒ 

  4. Under Warehouse, enter your warehouse’s name as listed in Snowflake.

  5. If you have OAuth enabled on your organization, and you would like to use it on the connection, switch on OAuth access; see OAuth with Snowflake.
    Please note: Steps 9 - 11 are not applicable if you choose to use OAuth without a service account.

  6. Under User, enter your Snowflake username.

  7. Under Password, enter your Snowflake password.

  8. [optional] Under Role, you can specify a Snowflake role to be used on this connection.

    company apps

  9. [optional] UnderΒ Connection Features,Β you can set a connection timeout and/orΒ enable write access.

  10. After completing the form, click theΒ CreateΒ button.

    company apps


Databricks

Prerequisites

  • You must create an Azure Databricks workspace.
  • Your Databricks workspace must be Premium tier.
  • A customized networking configuration is required to support Private Link.

Provide Databricks Resource ID to Sigma

Follow the steps below to provide Sigma with the Resource ID to create a private link for your organization.Β Β 

  1. In Azure Services, hover over Azure Databricks and click Create.

    company apps

  2. Click JSON View in the top-right corner of the databricks workspace page in Azure.Β 

  3. On the Networking tab, you must check Yes for Deploy Azure Databricks workspace in your own Virtual Network and enter pre-configured virtual network and two subnets within the virtual network CIDR range for public and private subnet fields.

  4. Copy the Resource ID. In Location, copy the Region Name for the Databricks warehouse. Send these two values to your Sigma account manager.Β 

    company apps

Private Link Approval

Follow the steps below to approve the Private Link after Sigma notifies you.Β 

  1. In the Azure portal, go to Azure Databricks.

  2. Click the selected Azure Databricks workspace.

  3. Click Networking on the left panel.

  4. Click on Private endpoint connections.

  5. Select the newly created private endpoint. The status will be Pending. Check Approve to approve the endpoint. Copy the name of the private endpoint, it's required when you configure Sigma.Β 

    company apps

Configure Databricks Connection

  1. In the Databricks section of Azure, click on the warehouse instance > Databricks Workspace.

  2. Click Launch Workspace.

    company apps

  3. In Databricks, select SQL in the Data Science & Engineering dropdown.Β 

    company apps

  4. Click Review SQL Warehouses.Β 

    company apps

  5. Select the warehouse.Β 

  6. Click the Connection details tab.Β 

  7. Copy the HTTP path value in Databricks as it's required in the Sigma UI.Β 

    company apps

  8. Go to User Settings in Databricks by clicking on your username.Β 

    company apps

  9. Click Personal access tokens tab.Β 

  10. Click Generate new token.

  11. In the Lifetime field, set the duration of the private link. The link will expire based on the value.Β 

  12. Enter a value in the Comment field.

    company apps

  13. Click Generate. Copy this token as it's required in the Sigma UI.

    company apps

  14. In Sigma, go to Admin > Connections > Databricks.

  15. In the Host field, enter the private endpoint you copied when you approved the endpoint, in the following format.

    <private_endpoint_name>.pl-auth.azuredatabricks.net

    For example, if the private endpoint name is databricks-endpoint, then you would enter the following in the Host field.
    databrick-endpoint.pl-auth.azuredatabricks.net

    πŸ“˜

    To locate the private endpoint's name, go to your Azure portal > click the Azure Databricks Workspace > click Networking on the left panel. The private endpoint name is displayed in the Private Endpoint column in Private endpoint connections.

  16. Paste the HTTP path value from Azure into the HTTP path field in Sigma.Β 

  17. Paste the token you created in Azure and enter into Access token field in Sigma.Β Β 

    company apps

  18. [optional] Under Connection Features,Β you can set a connection timeout and/orΒ enable write access.

  19. [optional] In the Connection queue size field, define the number of interactive queries Sigma can run on this connection concurrently.

  20. ClickΒ CreateΒ in Sigma.Β 

    company apps


PostgreSQL

Prerequisites

  • To create a Private Link connection to PostgreSQL in Azure, the postgres server must be a single server, not a flexible server.Β 
  • Your PostgreSQL instance must be General Purpose tier.

πŸ“˜

Currently, Azure only supports creating a Private Link to Azure Database for PostgreSQL single server (Resource Type).

Provide PostgreSQL Info to Sigma

Follow the steps below to provide Sigma with the Resource ID to create a private link for your organization.Β Β 

  1. Click the JSON View on the top-right corner of PostgreSQL server page in your Azure portal.

    company apps

  2. Copy the Resource ID and send to your Sigma account manager.

Private Link Approval

Follow the steps below to approve the Private Link provided by Sigma.

  1. In Azure, go to Azure Database for PostgreSQL servers.

  2. Click on the selected PostgreSQL server created by the private link.

  3. Click on Private endpoint connections on the left panel of the PostgreSQL server page. Copy the name of the private endpoint as you will need it when you configure Sigma.Β 

    company appsΒ 

  4. Select the recently created private endpoint connection

  5. The status will be Pending. Check Approve to approve the endpoint.

  6. The private endpoint connection will change to Accepted.

Configure PostgreSQL Connection

Follow the steps below to configure your Sigma PostgreSQL connection to use Private Link.

  1. In the Host field, enter the private endpoint you copied in the step above in the following format:Β 

    \<private\_endpoint\_name>.privatelink.sigma.internal

    For example, if the private endpoint name is postgresql-endpoint, then the Server field is:

    postgresql-endpoint.privatelink.sigma.internal

  2. In the User field, enter the Admin Username found in the PostgreSQL server page. For example, user@postgres_test.Β 

  3. In the Port field, enter the PostgreSQL port number.Β 

  4. Β In the Password field, enter the password used to access your data warehouse. Β 

  5. In the Database field, enter the name of your database.Β 

  6. Toggle Enable DNS on to ensure encryption.Β 

  7. [optional] SSH isn't required for this connection.Β 

company apps