I'm querying several different databases with the exact same sql statement. The only difference between them is the database name and sql_last_value based on ID. Is it possible to use one jdbc input so that it will cover all databases and create separate last_run_metadata_path?
Let's say I'm using two databases: CARS, SCOOTERS
My queries would look like this:
select * from CARS
select * from SCOOTERS
So the input would run both queries and create two separate last_run_metadata_path files, for example:
If not, i will use separate jdbc input entries.