Hi team,
Recently, I've been asked to create a custom schedule for a client. I've read some documentation and found this example:
datagroup: orders_datagroup {
sql_trigger: SELECT max(id) FROM my_tablename ;;
max_cache_age: "24 hours"
label: "ETL ID added"
description: "Triggered when new ID is added to ETL log"
}
In my case, I change my_tablename for "SCHEMA"."TABLE_NAME".
-- Does this make sense? --
And can I test this datagroup without deploying this change? I didn't want to way till next day to see if it worked.