Supported data stores

Purview supports the following data stores. Select each data store to learn the supported capabilities and the corresponding configurations in details.

Purview data sources

Category Data Store Technical metadata Classification Lineage Access Policy
Azure Azure Blob Storage Yes Yes Limited* Yes
Azure Cosmos DB Yes Yes No* No
Azure Data Explorer Yes Yes No* No
Azure Data Lake Storage Gen1 Yes Yes Limited* No
Azure Data Lake Storage Gen2 Yes Yes Limited* Yes
Azure Database for MySQL Yes Yes No* No
Azure Database for PostgreSQL Yes Yes No* No
Azure Dedicated SQL pool (formerly SQL DW) Yes Yes No* No
Azure Files Yes Yes Limited* No
Azure SQL Database Yes Yes No* No
Azure SQL Database Managed Instance Yes Yes No* No
Azure Synapse Analytics (Workspace) Yes Yes Yes - Synapse pipelines No
Database Amazon RDS Yes Yes No No
Cassandra Yes No Yes No
DB2 Yes No Yes No
Google BigQuery Yes No Yes No
Hive Metastore Database Yes No Yes* No
MySQL Yes No Yes No
Oracle Yes No Yes* No
PostgreSQL Yes No Yes No
Snowflake Yes No Yes No
SQL Server Yes Yes No* No
Teradata Yes No Yes* No
File Amazon S3 Yes Yes Limited* No
Services and apps Erwin Yes No Yes No
Looker Yes No Yes No
Power BI Yes No Yes No
Salesforce Yes No No No
SAP ECC Yes No Yes* No
SAP S/4HANA Yes No Yes* No

* Besides the lineage on assets within the data source, lineage is also supported if dataset is used as a source/sink in Data Factory or Synapse pipeline.

Note

Currently, Purview can't scan an asset that has /, \, or # in its name. To scope your scan and avoid scanning assets that have those characters in the asset name, use the example in Register and scan an Azure SQL Database.

Scan regions

The following is a list of all the Azure data source (data center) regions where the Purview scanner runs. If your Azure data source is in a region outside of this list, the scanner will run in the region of your Purview instance.

Purview scanner regions

  • Australia East
  • Australia Southeast
  • Brazil South
  • Canada Central
  • Central India
  • Central US
  • East Asia
  • East US
  • East US 2
  • France Central
  • Japan East
  • Korea Central
  • North Central US
  • North Europe
  • South Africa North
  • South Central US
  • Southeast Asia
  • UAE North
  • UK South
  • West Central US
  • West Europe
  • West US
  • West US 2

Next steps