JDBC - Using parameter for both SQL statement and last_run_metadata_path


(PB) #1

Hello,

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: .last_run_query_CARS and .last_run_query_SCOOTERS.
If not, i will use separate jdbc input entries.
Thanks.