sys.external_data_sources (Transact-SQL)

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2016)yesAzure SQL DatabaseyesAzure SQL Data Warehouse yesParallel Data Warehouse

Contains a row for each external data source in the current database for SQL Server, SQL Database, and SQL Data Warehouse.

Contains a row for each external data source on the server for Parallel Data Warehouse.

Column Name Data Type Description Range
data_source_id int Object ID for the external data source.
name sysname Name of the external data source.
location nvarchar(4000) The connection string, which includes the protocol, IP address, and port for the external data source.
type_desc nvarchar(255) Data source type displayed as a string. HADOOP, RDBMS, SHARD_MAP_MANAGER, RemoteDataArchiveTypeExtDataSource
type tinyint Data source type displayed as a number. 0 - HADOOP

1 - RDBMS

2 - SHARD_MAP_MANAGER

3 - RemoteDataArchiveTypeExtDataSource
resource_manager_location nvarchar(4000) For type HADOOP, the IP and port location of the Hadoop resource manager. This is used for submitting a job on a Hadoop data source.

NULL for other types of external data sources.
credential_id int The object ID of the database scoped credential used to connect to the external data source.
database_name sysname For type RDBMS, the name of the remote database. For type, SHARD_MAP_MANAGER, the name of the shard map manager database. NULL for other types of external data sources.
shard_map_name sysname For type SHARD_MAP_MANAGER, the name of the shard map. NULL for other types of external data sources.

Permissions

The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.

See Also

sys.external_file_formats (Transact-SQL)
sys.external_tables (Transact-SQL)
CREATE EXTERNAL DATA SOURCE (Transact-SQL)