Skip to content

sys-external-data-sources-transact-sql.md

Latest commit

 

History

History
59 lines (47 loc) · 4.83 KB

sys-external-data-sources-transact-sql.md

File metadata and controls

59 lines (47 loc) · 4.83 KB
title sys.external_data_sources (Transact-SQL)
description The sys.external_data_sources system catalog view contains a row for each external data source in the current database.
author rwestMSFT
ms.author randolphwest
ms.reviewer hudequei, wiassaf, mikeray
ms.date 05/13/2025
ms.service sql
ms.subservice system-objects
ms.topic reference
ms.custom
ignite-2025
f1_keywords
external_data_sources
sys.external_data_sources
dev_langs
TSQL
monikerRange >=aps-pdw-2016 || =azuresqldb-current || =azure-sqldw-latest || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric-sqldb

sys.external_data_sources (Transact-SQL)

[!INCLUDE sqlserver2016-asdb-asdbmi-asa-pdw-fabricsqldb]

Contains a row for each external data source in the current database for [!INCLUDEssNoVersion], [!INCLUDEssazure-sqldb], and [!INCLUDEssazuresynapse-md].

Contains a row for each external data source on the server for [!INCLUDEssPDW].

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, REMOTE_DATA_ARCHIVE, BLOB_STORAGE, NONE
type tinyint Data source type displayed as a number. 0 - HADOOP

1 - RDBMS

2 - SHARD_MAP_MANAGER

3 - REMOTE_DATA_ARCHIVE

4 - internal use only

5 - BLOB_STORAGE

6 - NONE
resource_manager_location nvarchar(4000) For type HADOOP, the IP and port location of the Hadoop Resource Manager. The resource_manager_location 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.
connection_options nvarchar(4000) Applies to: [!INCLUDEsssql19-md] and later. The connection_options will contain the same string from your CONNECTION_OPTIONS parameter from CREATE EXTERNAL DATA SOURCE CONNECTION_OPTIONS.

In [!INCLUDEsssql19-md], this is a semicolon-separated string.
In [!INCLUDEsssql22-md], this can also be a JSON-formatted string.
pushdown nvarchar(256) Applies to: [!INCLUDEsssql19-md] and later.

NOT NULL. Whether pushdown is enabled. For more information, see Pushdown computations in PolyBase.		 ON, OFF

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.

Remarks

In [!INCLUDEsssql22-md], SQL Server support for HDFS Cloudera (CDP) and Hortonworks (HDP) external data sources are retired and not included. There's no need to use the CREATE EXTERNAL DATA SOURCE ... TYPE argument in [!INCLUDEsssql22-md].

Related content