Sometimes, you have to use external systems like Fivetran to load data into your datawarehouse. How can you verify when these systems have successfully loaded your data? With Shipyard, you can run SQL queries against Snowflake to verify that new rows are loaded for various timestamps, IDs, etc. If data is found, you can immediately kick off Coalesce jobs related to these datasets. This setup makes it easier to spread out the execution of your Coalesce jobs and guarantee that they run as soon as the right data is loaded.

‍