Hi,Colin Ferguson
Create database credentials through CREATE DATABASE SCOPED CREDENTIAL.
Database scoped credentials are stored in the system catalog of SQL Server and are stored in an encrypted manner.
When performing tasks, the PolyBase engine uses the credentials stored in the system to establish a connection with the external data source.
This is because the credentials are bound together with the external data source definition. Then create the external data source through CREATE EXTERNAL DATA SOURCE and specify the credentials just created.
Since the scoped credentials are stored in the system catalog of SQL Server, they can only be accessed with the appropriate permissions, ensuring the security of the credentials during transmission.
When creating an external data source, different database drivers support different encryption options. Refer to CREATE EXTERNAL DATA SOURCE CONNECTION_OPTIONS.
Best Regards,
Mikey Qiao
If you're satisfied with the answer, don't forget to "Accept it," as this will help others who have similar questions to yours.