Azure synapse external table definition

Question

how to view the definition (especially the path/datatype/format) of the external table ?

Answer 1

Hi,

If this is for Serverless SQL Pools then you can use the following DMVs:

select * from sys.external_tables
select * from sys.external_file_formats
select * from sys.external_data_sources

select et.name as TableName,
et.location as TableLocation,
ef.name as FileFormatName,
ef.format_type as FileFormatType,
es.name as DataSourceName,
es.location as DataSourceLocation
from sys.external_tables et
inner join sys.external_file_formats ef on ef.file_format_id = et.file_format_id
inner join sys.external_data_sources es on es.data_source_id = et.data_source_id