Azure Synapse

Connect your Azure Synapse workspace to Wobby

Follow this guide to connect your Azure Synapse Analytics workspace to Wobby and start building AI agents on your data.

To connect Azure Synapse to Wobby, you’ll need to:

• Create a SQL login and user in Synapse with read-only permissions.

• Allow Wobby’s static IP address through your firewall.

• Set up the connection in the Wobby interface.

⚠️ Wobby’s agents only run read-only queries on your data. No write or admin privileges are required.

1. Create Login and User in Synapse

You’ll need a SQL login and database user for Wobby with read-only access. Use the following SQL commands, updating placeholders for your environment:

-- Create a server-level login
CREATE LOGIN wobby_synapse WITH PASSWORD = '<your_secure_password>';

-- Switch to your target database
USE [YourDatabaseName];

-- Create a user in the database linked to the login
CREATE USER wobby_user FOR LOGIN wobby_synapse;

-- Grant read-only access to all tables
ALTER ROLE db_datareader ADD MEMBER wobby_user;

2. Allow Wobby’s IP Address

To allow Wobby’s agents to connect, whitelist this static IP address in your Azure Synapse firewall rules:

34.77.172.158

Add this IP under "Firewall rules" for your Synapse workspace or SQL server.

3. Set Up the Connection in Wobby

Go to Wobby → Data Sources and click New Azure Synapse Connection. Fill in the following fields:

• Name: Choose a descriptive name (e.g., Sales Synapse)

• Server: Your Synapse server address (e.g., your-server.database.windows.net)

• Port: 1433 (default)

• Database Name: The database you want to connect

• Schema: (Optional) Default is usually dbo

• Encryption: Enabled (recommended)

• Username: wobby_synapse

• Password: The password you set earlier

Once completed, click Test Connection to verify, then Save Connection.