If you are using a Batch Append Files block, Omniscope will watch for changes to any file matching your "All/part of filename" filter. If any change, the entire append will be re-run. Omniscope does not currently support partial refresh of Batch Append blocks.

Is it in the pipeline? Similarly is the same behavious observed with direct database connectivity and updating?

A database connection using SQL cannot detect changes in the database in a generic fashion, neither can it detect which rows have changed. Your database table might have a row containing some kind of timestamp, other tables might have IDs, others might have nothing helpful, and different database vendors have different variations of SQL.

Currently Omniscope can only refresh from database tables on a schedule of your choosing, and using a full data dump. In future we may add the ability to define SQL queries which are used to trigger refreshes.

For either of these issues if they are of importance please post as in Ideas and vote on them. Subject to demand we will implement in 2.7 or later.