List View of Activity Log
Examine the list view of the activity log interface to obtain more detailed information.
The date and time of the activity, such as April 16, 6:00 PM.
The username of the activity initiator.
The IP address of the Arcadia instance that originated the request.
The type of event that generated the activity, such as View, Create, and Update.
The component of the activity, such as Dashboard, Data Connection, Dataset, Mixed, Snapshots, Thumbnail, or Workspaces.
The ID of the component.
The ID of the visual that generates the activity. Click on this number to navigate to the visual.
The ID of the dashboard that generates the activity. Click on this number to navigate to the dashboard.
The ID of the dataset that generates the activity. Click on this number to navigate to the Dataset Detail interface for that dataset.
The name of the data connection for the activity. Click on this name to navigate to the Datasets interface for that connection.
The type of connection, such as arcengine, impala, hive, and so on.
If the connection is of arcengine type, you can have a fallback engine enabled. For example, the second row shows that Dashboard ID = 500 uses the fallback option. Typically, the value of this column is N/A.
This column indicates whether the query was served from the cache; values are true or false.
This column indicates that CDP Data Visualization served the query from the cache after checking the base data to confirm that no changes occurred between the cache capture and the time the query ran in the cache. Values are true or false.
This column indicates if the query execution used an analytical view; values are Yes, No, or N/A.
The duration of the activity, in seconds.
The completion status of the query, such as Done, if it is running, or if it is in an error state.
This column shows if there is an error in any of the actions.
You can examine the SQL statement for each query event.
By default, CDP Data Visualization hides the SQL statements. To see all statements, click the Plus icon under the column title Query. To hide all statements, click the Minus icon. To see only specific queries, click Show SQL in the specific row.
For example, this is the SQL statement for the first Dashboard (component ID=500):
SELECT cast((((TA_0.'duration') - 0.007558) / 1.5571718) as bigint) as 'Buckets', sum(1) as 'Record Count' FROM 'default'.'historical_queries' TA_0 WHERE TA_0.'start_date' = to_date(date_sub(now(), interval 1 Days)) GROUP BY 1 LIMIT 5000