Multiple Postgres DB

[rriley99]

I have a postgres server that has about 5 different databases I want to consume, is it possible to parameterize the connection to pass the db_name like a table_name?

Thanks.

[mdawlekar]

Yes @rriley99  you can pass the DB connection details like DB Name and other details as parameterize properties while running the pipeline.

[virender_prajap · Accepted solution]

Create a Postgres Dynamic Account and parameterized your credentials as needed.
Also ensure that the parameter which you have defined in the connection should be available in your pipeline with credentials.
During the execution your pipeline will send these credentials to the connection.

[rriley99]

Fantastic, thank you!