/
Working with ROLAP queries on Postgres data source
Document toolboxDocument toolbox

Working with ROLAP queries on Postgres data source

Owned by Sarabjeet Kaur
Last updated: Dec 30, 2024
1 min read

Kyvos supports ROLAP queries on PostgreSQL data source with No-Spark.

Note

  • Queries will be served from an external SQL engine. 

  • The kyvos.connection.defaultsqlengine=true property must not be true on any other connection, such as MSSQL, Postgres, or any other connection. 

To create a PostgreSQL connection for ROLAP queries, perform the following steps.

  1. Enter a name for the PostgreSQL connection.

  2. Select WAREHOUSE as Category value.

  3. Select the 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.sqlEngine= true

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

    4. kyvos.connection.sqlengineType=POSTGRES

  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. 

image-20241227-080616.png

 

Copyright Kyvos, Inc. All rights reserved.