Azure Synapse Analytics (formerly SQL Data Warehouse) support

See also:

• Connect to Azure Synapse Analytics
• Connecting to Azure Synapse Analytics Using Service Principal
• Azure Synapse Pipelines

info

Dataedo supports both Dedicated and Serverless SQL pools.

Catalog and documentation

Data Dictionary

Dataedo imports the following report objects from Synapse:

• Tables
• Views
• Procedures
• Functions
• Dependencies
• External data sources (as Linked Sources)

Descriptions, aliases, and custom fields

When technical metadata is imported, users will be able to edit descriptions of each object and element, provide meaningful aliases (titles), and document everything with additional custom fields. Dataedo reads extended properties from the following Synapse objects:

• Tables and External Tables
  • Columns
• Views
  • Columns
• Procedures
  • Parameters
• Functions
  • Parameters

Data Profiling

Users will be able to run data profiling for a table or view in the warehouse and then save selected data in the repository. This data will be available from Desktop and Web.

Data Quality

Users will be able to check if data in Synapse tables is accurate, consistent, complete, and reliable using Data Quality functionality. Data Quality requires SELECT permission over the tested object.

Connection requirements

• Importing database schema requires a certain access level in the documented database. The user used for importing or updating the schema should at least have the "View definition" permission granted on all objects that are to be documented. "Select" also works on tables and views.
• To be able to import dependencies, the user needs to have SELECT permission on the sys.sql_expression_dependencies view.

Connecting to Synapse

For detailed connection instructions, see:

• Connecting to Azure Synapse Analytics
• Connecting to Azure Synapse Analytics Using Service Principal

Specification

Imported metadata

	Imported	Editable
Tables & External Tables	✅	✅
Columns	✅	✅
Data types	✅
Nullability	✅
Description	✅	✅
Identity (is identity on)	✅
Default value	✅	✅
Views	✅	✅
Description	✅	✅
Script	✅	✅
Columns	✅
Data types	✅
Nullability	✅
Description	✅	✅
Identity (is identity on)	✅
Default value	✅	✅
Procedures	✅	✅
Script	✅	✅
Parameters	✅	✅
Functions	✅	✅
Script	✅	✅
Parameters	✅	✅
Returned value	✅	✅
Dependencies	✅	✅

Supported features

Feature	Imported
Import comments	✅
Write comments back
Data profiling	✅
Reference data (import lookups)
Importing from DDL
Generating DDL	✅
FK relationship tester	✅

Comments

Dataedo reads comments from the following Azure Synapse Analytics objects:

Object	Read	Write back
Tables comments	✅
External tables comments	✅
Views comments	✅

Data Lineage

Source	Method	Version
Views (column-level)	From SQL parsing	✅
External Tables (object-level)	From sys.external_tables and sys.external_data_sources views	23.2 (2023)
COPY INTO tables (object-level)	Parsing queries from sys.dm_pdw_exec_request views	23.2 (2023)

Column-level data lineage is retrieved using the Dataedo SQL parser. Read more about the capabilities of the Transact-SQL SQL parser.