...
Parameter | Description |
|---|---|
Name | Enter SanityConnection as a name for sanity suite connection. |
Category | Select the Warehouse option. |
Provider | Select the Generic option. |
Driver | Enter the Driver class as com.microsoft.sqlserver.jdbc.SQLServerDriver |
URL | Enter URL as jdbc:sqlserver://sqlServerIp:port;databaseName=yourDatabaseName;encrypt=true;trustServerCertificate=true |
Username | Enter your SQL Server username. |
Password | Enter your SQL Server password. |
Spark ReadMethod | Select JDBC |
Schema Enabled | Select this checkbox to enable schema. |
Properties | Click Properties to view or set properties. You need to add a property to make the connection visible
|