PostgreSQL SSH

PostgreSQL is the most efficient general-purpose database for creating Data Warehouses and Data Lakes due to its efficiency in complex joins and high availability during insertions of high volumes of information.

Don't have a database?

See this tutorial on how to create a PostgreSQL database on AWS

SSH pipeline differs from traditional pipeline in that it connects to the database through an intermediate server, also called a tunnel or bastion.

If you want to use the PostgreSQL destination directly (without an intermediate SSH server) see this article

Before adding the database, make sure that the user and the bank server are accessible to our IPs that are listed here and enable the connection to the intermediary server on the port that will be used, then follow the steps below:

1) Login to the Kondado platform

2) Navigate to add destinations page click “New Destination” and select the PostgreSQL SSH destination

3) Fill in your database information as shown below:

Name: This is the internal description of your destination on the Kondado platform

Server Address: The address of the intermediary server that will access your database

Server port: The passthru server port that will access your database

Server user: The passthru server user who will access database

Server PEM Key: The text of the file with the PEM key for passthru server access

Database address: The server address of your database

Database port: The port of your database

Database User: The username Kondado will use to enter data into your database. This user must have DROP, INSERT, CREATE, ALTER, SELECT and DELETE permissions

Database Password: The database user's password

Database: the name of the database

Schema: inform a schema or leave the default “public” [1]

Click save and your new destination will be created!

[1] Kondado will try to create the schema with the value informed in the “schema” parameter and if this is not possible (for example, due to lack of permission), the public schema will be used. Even if the schema already exists, Kondado must have permission to create schemas (“GRANT CREATE ON DATABASE db TO user”) if you do not want to use the public schema. For existing schemas, it is also important that the user registered at Kondado has permission to use the schema (“GRANT USAGE ON SCHEMA schema_name TO user;”)