In my Sql query inside the collector files I want to avoid grabbing the same records with each scraping interval, and in order to grab only the delta records, I wanted to use the min_interval defined in the sql_exporter.yml as a variable.
something like that
select all records where last_modified_date >= current(time)-min_interval.
is that possible?