System Tables: View Track Trend Task

From Explore Analytics: The Wiki
Jump to navigation Jump to search

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.