Databases, warehouses and search stores SPSync copies SharePoint lists into

Destinations at a glance

The licence column names the destination family a licence covers. Embeddings on sync means SPSync writes a vector for each row as it copies. In the last column, listed means the store is on Microsoft's list of Copilot Studio real-time knowledge connectors, a preview feature when we checked on 22 October 2026.

How to choose a destination

Start with whoever reads the data. When a Power BI report, an internal app or an agent with a SQL tool reads it, the usual answer is a relational database your team already runs. That tends to be SQL Server or Azure SQL in a Microsoft shop, and Postgres or MySQL elsewhere. Lookups arrive as key columns and multi-value columns as child tables, so a report joins two lists the way it joins any other tables.

A warehouse or a lake makes sense when the lists feed a data platform you already have. BigQuery, Databricks, ClickHouse and DuckDB take the tables directly. Parquet is the route into the platforms SPSync does not write to yet. Each run replaces a current.parquet file per table, which Snowflake, Synapse, Fabric and Redshift can load or query today, and each of their pages shows how.

Pick a search or vector store when people, or an agent, look for rows by what the text means. Postgres with pgvector and Azure AI Search are the two where SPSync writes the embedding itself. If your managed Postgres offers the pgvector extension, the pgvector destination can write to it. Elasticsearch, OpenSearch and the other search stores suit keyword and filtered search over the same columns.

For a Copilot Studio agent, the last column of the table matters most. A copy in a store Microsoft lists can be added to the agent as knowledge through that connector. For a copy anywhere else, a custom agent can query it with a read-only SQL tool, the route the AI and agents hub walks through. Either way the agent reads the copy with a database login and needs no Graph permission of its own. Each destination page covers the setup, the type mapping and the limits for that store.