Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Enter a name for the PostgreSQL connection.

  2. Select WAREHOUSE as Category value.

  3. Select GENERIC as the POSTGRES Provider valuefrom the list.Provide the org.postgresql.Driver as the driver class

  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 value in Spark Read Method field.

  8. Select the Schema Enabled checkbox to enable schema. Add a new property by clicking the Properties link.

    1. Enter property’s name as kyvos.connection.isRead

    2. Enter its value as True.

  9. After you finish configuring the settings using the table shown below the screenshot, click the Test button from the top left to validate the connection settings.

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

...