I have some Big Query datasets connected to my projects and I want them to update automatically. I've created a scenario that builds said datasets but they don't seem to refresh the data all the way from Big Query.
In your scenario, you may need to build at least your first datasets (from the BigQuery ones) in 'force rebuild' mode. DSS does not have automatic change tracking on SQL datasets