> ## Documentation Index
> Fetch the complete documentation index at: https://docs.myquery.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Azure Synapse Analytics

> Designed for large-scale data warehousing in the Microsoft ecosystem.

## **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).

### **Method A: Parameters**

* **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.

### **Method B: Connection String**

* **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;
  ```