Skip to content

Deployment History and Execution History

History Overview#

You can access both the Deployment and the Execution History of a node in the Inspector.

Viewing the Global Deployment History#

Every user has access to the Global Deployment History in Datameer.

  • Clicking on "Deployments" opens the History from where you can investigate the following information:

    • Snowflake Target: Snowflake Schema, name and deploying version
    • Deployed From: Datameer Project and dataset name
    • Deployed At: Date and timestamp with region
    • Owner: owner of the deployed dataset

  • Clicking the link in the "Deployed From" column opens the associated Project's Workbench.

Browsing the Global Deployment History#

You can perform a search in the search bar to filter by:

  • database, schema and table
  • Snowflake fully qualified name DB.SCHEMA.TABLE
  • part of Snowflake fully qualified name DB.SCHEMA, DB.TABLE or SCHEMA.TABLE

Filtering works case sensitive. Enter at least three characters in the search field.

Viewing the Deploying History#

The Deploying History provides information for all deployed nodes, such as a history timestamp or status.

To view the Deployment History of a deployed node, select the node and the click on "Deployment" in the 'Info' tab. The Deployment History' dialog opens.

You can investigate the following information in reverse chronological order:

  • deployment version
  • deployment message (from the 'Deploy to Snowflake' dialog or if you re-deploy a node)
  • scheduling information
  • user who deployed the node
  • deployment timestamp

You can also copy the SQL query or restore a version from here:

To copy the SQL query, open the required deployment version line, hover over the collapsed SQL query and click on "Copy to Clipboard ". The query is copied to your clipboard.

To restore a former version:

  1. Open the required deployment version line, hover over the 'Version' column and click on "Restore". The dialog 'Restore Previous Deployment to Snowflake' opens.

  2. Enter a commit message and confirm with "Restore". The version is restored.

Viewing the Execution History#

The Execution History provides metadata information on deployed nodes, such as error messages, execution duration, etc.

To view the Execution History of a deployed node, select the node and the click on "Execution" in the 'Info' tab. The Execution History' dialog opens.

You can investigate the following information in reverse chronological order:

  • start timestamp
  • user who triggered the execution
  • number of records
  • execution duration in seconds and milliseconds
  • end timestamp
  • warehouse
  • deployment version with link to the Deployment History

Clicking on the number in the column 'Deployment Version' forwards you automatically to the associated Deployment History entry.