githubEdit

How do I set up a MySQL connection to Sigma using AWS PrivateLink?

Context When connecting your MySQL database to Sigma Computing, you may want to use AWS PrivateLink for enhanced security. This creates a private connection between your VPC and Sigma's service without exposing traffic to the public internet. Answer Follow these steps to set up a MySQL connection to Sigma using AWS PrivateLink: Set up a VPC endpoint in your AWS environment: Create a VPC endpoint service in your environment Note the service name (format will be similar to: com.amazonaws.vpce.region.vpce-svc-xxxxxxxx) Share the following information with your Sigma Account Executive: VPC endpoint service name Availability zone names and IDs for your region (e.g., NAME: us-east-1a, ID: use1-az1) When Sigma provides their service cluster IPs, whitelist them in your security group: Sign in to your cloud portal Navigate to Administrator → Infrastructure → your-environment Select the "Security Group Rules" tab Click "+ Add" Configure the rule: Source Type: IP Address IP CIDR: Custom Enter the provided IP address Protocol: TCP Port Range: 3306 (MySQL port) Add a description Click "Add" Once Sigma provides the Account URL (format: xxx.privatelink.sigma.internal): Use this URL as the HOST in your Sigma connection settings Authorize the connection in your VPC endpoint For additional information, refer to the following resources: AWS PrivateLink Connections Documentation MySQL Connection Settings in Sigma

Last updated

Was this helpful?