...
To create MSSQL Warehouse connection for sanity suite, perform the following steps.
...
Name: SanityConnection
...
Parameter | Description |
|---|---|
Name | Enter SanityConnection as a name. |
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 |
...
Password: yourSQLServerPassword
...
Spark Read Method: JDBC
...
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
|