Azure SQL - Go Fig Documentation

Guide to Connect Azure SQL:

Create a dedicated read-only user for Go Fig. (Recommended)
Whitelist Go Fig’s IP address in your Azure SQL firewall rules: 35.185.38.164
Collect the following details:

Azure SQL server name (e.g., myserver.database.windows.net)
Database name
Username and password with read permissions
Port number (default: 1433)

1) Create a read-only user (recommended)

Create a dedicated Go Fig user with read-only access so Go Fig never has write access:

-- Create login at server level (master database)
USE master;
CREATE LOGIN gofig_user WITH PASSWORD = 'StrongPassword123!';

-- Create user in your database and grant read-only access
USE your_database;
CREATE USER gofig_user FOR LOGIN gofig_user;
ALTER ROLE db_datareader ADD MEMBER gofig_user;

Set a strong password and store it securely. Never use your admin credentials for the connection.

Finding connection details: In Azure Portal → SQL database → Connection strings to find your server name, database name, and port.

2) Whitelist Go Fig’s IP address

Azure SQL blocks external connections by default. In Azure Portal, go to your SQL server (not the database) → Security → Networking, then under Firewall rules add a rule with both Start IP and End IP set to 35.185.38.164 and click Save.

Firewall rules are set at the SQL server level and apply to all databases on that server.

3) Connect Go Fig to Azure SQL

Add Azure SQL connection

Navigate to your Organization Data page and click Add data source. Select Azure SQL from the list of database connections.

The Connect a new data source modal on the Database tab with the Azure SQL Server connector tile highlighted.

Enter connection details

Fill in your Azure SQL connection information:

Server: Your Azure SQL Server hostname (e.g., your-server.database.windows.net)
- Also supports Azure Synapse endpoints (e.g., your-server.sql.azuresynapse.net)
Database: The specific database to connect to
Username: SQL authentication username with read permissions
Password: SQL authentication password
Port: Port number (default: 1433)

The Azure SQL connection form with Server, Database, Username, Password, and Port fields.

Confirm IP access

Toggle the Confirm IP Access switch to confirm that you have added Go Fig’s IP address (35.185.38.164) to your Azure SQL firewall rules.

You cannot proceed until you confirm that the firewall has been configured.

Connect to Azure SQL

Click Connect to complete the setup. Go Fig will verify the connection, then encrypt and store your credentials securely.

Query timeouts: Queries are limited to 90 seconds. For complex queries, use views in Azure SQL to pre-aggregate data, or break your Flow into smaller steps.

​1) Create a read-only user (recommended)

​2) Whitelist Go Fig’s IP address

​3) Connect Go Fig to Azure SQL

1) Create a read-only user (recommended)

2) Whitelist Go Fig’s IP address

3) Connect Go Fig to Azure SQL