Azure Analytics

Source (Direct Connection) - Vendo reads directly from Azure Synapse tables and views. No data is copied into Vendo’s infrastructure.

Azure Analytics is the Vendo catalog entry for Azure Synapse warehouse connections.

What Vendo Accesses

Vendo connects to your Azure Synapse workspace and queries authorized tables for attribution, segments, SQL models, and AI-assisted analysis.

Data	Description
Tables	Any table the configured connection can read
Views	SQL views over warehouse or lake data
External Tables	Tables backed by Azure Data Lake Storage
Schemas	Schemas granted to the configured database principal

Behavior	Description
Direct Query	No import job is required; queries run in Azure Synapse
Self-Serve Catalog	Azure Analytics is available in the data warehouse category
Table Source Option	The source option is `Tables`, for Azure Synapse tables and views
Schema Discovery	Vendo discovers readable schemas and tables after the connection is saved

Setting	Value
App type	`azure_synapse`
Catalog name	Azure Analytics
Connection type	Direct connection (no sync)
Compute	Queries run in your Azure Synapse environment

Navigate to App Connections > Add App Connection
Select Azure Analytics from the data warehouse category
Provide the connection details for the Azure Synapse workspace, SQL endpoint, database, and schema scope
Use a database principal with read access to the tables or views Vendo should query
Save the connection so Vendo can test connectivity and discover schemas

Grant the connection principal the smallest read scope needed for the data you want to use:

Permission	Purpose
Connect to SQL endpoint	Reach the Synapse SQL endpoint
Database access	Use the target database
Schema access	Discover and address tables/views
`SELECT` on tables or views	Read source data

Azure Analytics is also available as a destination for warehouse activation. It accepts event, user, ad data, and conversion exports from Vendo.

See Azure Analytics destination for the activation-side behavior.

Symptom	What to check
Connection fails	Confirm the Synapse workspace, SQL endpoint, database, and credentials
Tables do not appear	Check schema visibility and `SELECT` grants for the configured principal
Queries time out	Check Synapse pool state, concurrency limits, and warehouse sizing
Network access fails	Confirm your network rules allow Vendo to reach the SQL endpoint