QuerySnapshot Table

QuerySnapshot holds the snapshot of data for a report

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for QuerySnapshot table

Database Column

Details

QuerySnapshotID

Type: integer. Key. Generated ID

A unique identifier for a query snapshot.

QueryContext

Type: text (max 200 characters). Key

The query context to partition different queries.

ComplianceSavedSearchID

Type: integer. Key. Nullable

The query definition this snapshot is for. Foreign key to the ComplianceSavedSearch table.

ComplianceOperatorID

Type: integer. Key

The operator who ran the report. Foreign key to the ComplianceOperator table.

SnapshotName

Type: text (max 200 characters)

Name of snapshot.

SnapshotSchema

Type: XML

Schema of snapshot.

SnapshotDate

Type: datetime

Date and time of snapshot (UTC)

SnapshotBuildTime

Type: big integer

Number of milliseconds taken to build the snapshot.

SnapshotRows

Type: big integer

Number of rows in the snapshot.