cancel
Showing results for 
Search instead for 
Did you mean: 

Multiple Postgres DB

rriley99
New Contributor III

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.

1 ACCEPTED SOLUTION

virender_prajap
New Contributor III

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.

virender_prajap_0-1691481034573.png

 

View solution in original post

3 REPLIES 3

mdawlekar
Employee

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

virender_prajap
New Contributor III

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.

virender_prajap_0-1691481034573.png

 

Fantastic, thank you!