how to dynamically change presto catalog properties from airpal tool

[surendraGaddam99]

Hi,

In reference.yml file we are configuring presto catalog props for example : prestoCatalog :oracle

Suppose i have 5 schemas in a dropdown and i want to connect to particular schema based on dropdown selection of user .

Below are my prestodb catalog configuration for one schema Is there any way to set the presto catalog connection properties dynamically ? presto-server-0.77/etc/catalog/oracle.properties

connector.name=oracle connection-url=jdbc:oracle:thin:@xxxx.com:1521:xxxx connection-user=AF310ST1 connection-password=test123

Is it possible to dynamically set these catalog values from Airpal application to which presto is connected. Suppose user wants to connect to some other schema eg: AA360ST2 then any way to set the catalog parameter dynamically from airpal application without restarting presto server.

Do i need to create 5 catalog prop files for each of the schema in presto server and connect to particular catalog based on user selection ?

Thanks Surendra