Azure Synapse Analytics

Security & Architecture Overview

Before connecting your data, it is critical to understand how MyQuery interacts with your infrastructure:

Schema-Only Access: MyQuery does not ingest or store your raw database records. We only read the metadata (table names, column types, and foreign key relationships) to build a semantic map for the AI.
Encrypted Storage: All connection credentials and “maps” are encrypted at rest using industry-standard AES-256 encryption.
Whitelisting: To allow MyQuery to reach your database, you must whitelist our outbound IP addresses in your firewall or cloud security groups (e.g., AWS Security Groups, Azure Firewall).

Server (Required): The Synapse SQL endpoint (e.g.,
your-workspace.sql.azuresynapse.net
).
Database (Required): The dedicated SQL pool name.
Username/Password: SQL Authentication credentials.

Format:

Server=tcp:[server],1433;Database=[db];User ID=[user];Password=[pass];Encrypt=true;

Example:

Server=tcp:myworkspace.sql.azuresynapse.net,1433;Database=AnalyticsPool;User ID=sqladmin;Password=Password123!;Encrypt=true;