...
Parameter | Description | ||
|---|---|---|---|
Name | Enter SanityConnection as a name. | ||
Category | Select the Warehouse option. | ||
Provider | Select the Generic MSSQL 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 Name: kyvos.connection.isRead |