| description | sys.external_data_sources (Transact-SQL) | |
|---|---|---|
| title | sys.external_data_sources (Transact-SQL) | Microsoft Docs | |
| ms.custom | ||
| ms.date | 03/14/2017 | |
| ms.prod | sql | |
| ms.prod_service | database-engine, sql-database, sql-data-warehouse, pdw | |
| ms.reviewer | ||
| ms.technology | system-objects | |
| ms.topic | reference | |
| dev_langs |
|
|
| ms.assetid | 1016db6e-9950-4ae2-a004-bd4171e27359 | |
| author | WilliamDAssafMSFT | |
| ms.author | wiassaf | |
| monikerRange | >=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDE sqlserver2016-asdb-asdbmi-asa-pdw]
Contains a row for each external data source in the current database for [!INCLUDEssNoVersion], [!INCLUDEssSDS], and [!INCLUDEssSDW].
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, 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. |
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.
sys.external_file_formats (Transact-SQL)
sys.external_tables (Transact-SQL)
CREATE EXTERNAL DATA SOURCE (Transact-SQL)