Overview

Beta

The Historical User Activity feature is currently in beta for the Analytics tool.


The user_activity table in the Analytics database tracks actions performed by users across your company account. The Analytics Cloud Connector Command Line Interface (CLI) enables you to leverage this table to sync your account's entire historical activity log to your destination database, such as Snowflake, SQL Server, ADLS, BigQuery, Fabric Lakehouse, and more. You can use this table to help your organization balance team workloads effectively, audit employee sessions during incidents, or review account interactions after an employee leaves the company.

Historical User Activity Data Sync Behavior

The following table outlines how the Historical User Activity feature affects existing and new users regarding the Analytics Cloud Connector CLI, data syncs, historical data behavior, and required actions:

Feature/Scenario

Existing Users

New Users

Analytics Cloud Connector CLI

Can continue using existing/old versions of the CLI and config.yaml files without modification, but an upgrade is recommended due to significant data volume in the user_activity table.

Will start fresh with the latest version of the Analytics Cloud Connector CLI.

Next/Initial User Activity Data Sync

If the destination table already contains 30 days of user activity data, the next data sync only loads new daily partitions (from yesterday onward).

Automatically imports historical user activity data into the destination table during the first run of the CLI.

Historical User Activity Data Behavior

Historical user activity data older than the current watermark will not import to the destination table automatically.

Historical user activity data is imported automatically since no prior user activity data exists in the destination table.

Action

Download the Analytics Cloud Connector CLI and run it for the first time

Partner Considerations