Page Comparison

...

1. Enter a name for the PostgreSQL connection.

2. Select WAREHOUSE as Category value.

3. Select the POSTGRES Generic Provider from the list.

4. The Driver Class field is displayed by default.

5. Provide the URL. The format for JDBC should be jdbc:postgresql://<IP/hostname/endpoint>:<Port>/<database>

6. Provide username and password.

7. Provide JDBC as the value in the Spark Read Method field.

8. Set the value of the following Properties for the Postgres connection:

   1. kyvos.connection.rawdata.enabled=true

   2. kyvos.connection.default.sqlengineTypesqlEngine= POSTGREStrue

   3. kyvos.connection.rawdata.supported.engines=POSTGRES

   4. kyvos.connection.default.sqlEnginesqlengineType= truePOSTGRES

9. After configuring the settings, click the Test button from the top left to validate the connection settings.

10. If the connection is valid, click the Save button. 

...