sys.dm_pdw_network_credentials (Transact-SQL)
Applies to: Analytics Platform System (PDW)
Returns a list of all network credentials stored in the Analytics Platform System (PDW) appliance for all target servers. Results are listed for the Control node, and every Compute node.
Column Name | Data Type | Description |
---|---|---|
pdw_node_id | int | Unique numeric id associated with the node. |
target_server_name | nvarchar(32) | IP address of the target server that Analytics Platform System (PDW) will access by using the username and password credentials. |
username | nvarchar(32) | Username for which the password is stored. |
last_modified | datetime | Datetime of the last operation that modified the credential. |
Permissions
Requires VIEW SERVER STATE.
General Remarks
The key for this dynamic management view is pdw_node_id plus target_server_name.
See Also
Azure Synapse Analytics and Parallel Data Warehouse Dynamic Management Views (Transact-SQL)
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for