About 21 of the tables are in the 15 minute refresh job. These are cleaned and then aggregated into six gold zone tables, two of which are used in dashboard reporting. The other 60 tables and their aggregations are in a job that is on a one hour schedule.

I played with continuous ingestion earlier this year and we had to turn it off because it was too expensive. I have not experimented yet with the integrated CDC feature.