Understanding the Sync Frequencies in the Snowflake Destination

When uploading data to Snowflake, we can find different options depending on our needs.

That is why we have different Sync Frequencies that we are going to explain in this article, so you can learn the different options we have when transferring our information using Dataslayer.

Schedule option

Select this option to schedule periodic uploads. Ideal for keeping the data updated periodically.

Dataslayer query setup screen with Google Ads as data source and Snowflake as destination, showing scheduled sync frequency configuration with hourly interval active
Schedule Option

Manual option

If you have a small volume of data (one month, or one year with a small amount of information): You can use the manual option for an immediate upload of your data. The manual option works in such a way that it uploads all the data at once.

Dataslayer sync frequency option set to manually import data without automationOne-month date range

Manually Splitted option

If you have a large volume of data (a month with a lot of data and many accounts, or more than a year), you can use the manually splitted option. To avoid timeouts, interruptions, and errors, this function divides the queries into groups and executes them periodically, so that the data will be uploaded little by little in an uninterrupted way.

Important: Note that this function can ONLY be executed when the query has TEMPORAL DIMENSIONS added.

When this option is used, the query can take a long time, so once executed, even if the browser is closed, the query will continue to run.

Dataslayer option to manually split data synchronization into smaller chunks for custom import control
Five years' date range

As always, please contact us via our live chat on our website or email if you still have doubts or questions. We are happy to help!