System Tables: View Track Trend Task
Contents
Introduction
This table lists the scheduled track trend tasks. These are scheduled jobs that collect trend data and store it in a trend table. The list includes all the trend jobs for all the users in your account.
Fields
In addition to the common fields, the View Track Trend Table includes the following fields
Actual Table Name
This is the actual name of the table in the explore data source that holds the trend data. It may be different than the Table Name because Explore Analytics may append a sequence number to the table name to make it unique in the database. Although the name may differ from the Table Name that was requested, its label will still match it.
Job
This is a reference to the Job table. It has fields that show the status of the job, last execution, next scheduled execution, and more.
Retention Period
If a non-zero number, it specifies the number of time units (e.g. days) that data will be retained in the trend table. The default is indefinite.
Retention Period Unit
The time unit for retention. “days”, “weeks”, “months” or “years”.
Table Name
The requested table name (and label) for the trend table created/updated by this job.
View
The view that generates the data to be collected in the trend table. This is a reference to the view in the view table.