Data Transformation preview and scheduling queries
I have two tables in my database:
- 5-min aggregated table with 5-min timestamps where the max timestamp is typically about 15 minutes behind real-time
- Hourly aggregated table with hourly timestamps and is typically 2 or 3 hours behind real-time
I setup a Data Transformations on both tables. My questions are as follows:
- I see the data preview in my 5-min transformation but not in the hourly. What are the start/end times of the data preview query?
- If I schedule my transformations to run periodically, what Frequency should I use for the 5-min and hourly schedules? Today, I'm using 60 min frequency for my 5-min transformation schedule. I guess this question is similar to my first question: what is the start/end times of the scheduler's query?