Inforiver
EDITable
EDITable
  • Introduction to EDITable
    • Why EDITable?
    • Supported Database Connections
  • Get Started
    • EDITable Pre-requisites
      • Admin consent for EDITable's Entra ID
        • Basic consent
        • Full admin consent
    • Install EDITable
    • Add EDITable visual
  • Getting Data into EDITable
    • Connect to Data
      • Get data
      • Assign fields
      • Configuration Steps
        • Configure source
        • Configure Columns
        • Configure Type 2 SCDs (Optional)
    • Create a Table
      • Create From Scratch
      • Use Existing Table
      • Import Data
  • Working with EDITable
    • EDITable interface
    • Manage Columns
      • General
      • Constraints
      • Lookup and Relation
      • Display
      • Import/Export Configuration
      • Add Database Column
      • Insert Column
    • Column Access Control
    • Row Identification
    • Table Operations (Insert/Update/Delete)
      • Edit data
      • Bulk Edit
      • Find and Replace
      • Insert rows
      • Insert Column
      • Import rows
      • Delete rows
      • Duplicate rows
      • Copy rows
      • Preview Changes
      • Reset Changes
    • Explore data
      • Search and filter
      • Sort and reorder
      • Show/Hide columns
      • Pin columns
      • Group Rows By
      • Summarize Column
    • Basic formatting
    • Conditional Formatting
  • Row Access Control
  • Approval Workflow
    • Review Changes - Workflow process
  • Type 2 SCDs
    • Configuring Type 2 SCDs in EDITable
  • Audit logs
  • Webhook
  • Display Settings
  • Commenting and Collaboration
    • Assign users & task status
    • View all comments & track changes
    • Comment Settings
  • Admin Portal & EDITable Console
    • Tables
    • Transaction Logs
    • Insights (Metrics)
    • Utility
      • Download Report
      • Pipeline
        • Power BI & EDITable deployment pipelines
        • Deployment in different destinations
        • Trigger deployment pipeline from external applications
        • Logs & other pipeline options
    • Manage Profile
    • Admin Portal
      • User Management
      • Settings
        • General Settings
        • Writeback Settings
          • Settings
          • EDITable managed DB
        • API token
    • Onboarding Actions
  • Formula and Functions
    • Conditional statements
      • IF
      • IFNA
      • SWITCH
    • Logical functions
      • AND
      • IN
      • ISBLANK
      • ISEMPTY
      • ISNUMBER
      • NOT
      • OR
      • XOR
    • Math functions
      • ABS
      • AVERAGE
      • AVERAGEIF
      • AVERAGEEXNEG
      • AVERAGEEXZERO
      • AVERAGEEXZERONEG
      • CEILING
      • COUNT
      • COUNTIF
      • DIVIDE
      • EVEN
      • EXP
      • FLOOR
      • LOG
      • MAX
      • MIN
      • PCT
      • POWER
    • Text formatting functions
    • Date functions
      • DATE
      • DATE.FORMAT
    • Other operators
  • Keyboard Shortcuts
  • Release Notes
    • EDITable - v1.7.5
    • EDITable - v1.7
    • EDITable - v1.6.5
    • EDITable - v1.6
Powered by GitBook
On this page
  • 1. Transaction details
  • 2. Search and filter transactions
  • 3. Export transaction Logs
  • 4. General details
  • 5. Error details
  1. Admin Portal & EDITable Console

Transaction Logs

PreviousTablesNextInsights (Metrics)

Last updated 3 months ago

The Transaction Logs section provides comprehensive details about all transactions made to the tables. This feature is crucial for auditing, tracking changes, and ensuring data integrity.

1. Transaction details

The transaction details include the following:

  • Transaction ID: Unique identifier for each transaction.

  • Table Name: Name of the table involved in the transaction.

  • Database Name: Name of the database where the table resides.

  • Source Name: Name of the data source (Azure SQL, Snowflake, etc.)

  • Transaction Type: Type of transaction, which can be Insert, Update, Delete or SCD Update (Slowly Changing Dimension Update)

  • Row Count: Number of rows affected by the transaction.

  • Duration: Time taken to complete the transaction.

  • Status: The transaction's status, whether successful or failed.

  • Started By: Name of the user who started the transaction

  • Started At: Date and time of the transaction.

2. Search and filter transactions

Users can look for a specific transaction using the search and filter options available here.

  • Search by Transaction ID: Search for specific transactions using their unique Transaction ID.

  • Filter by Transaction Type: Filter transactions by their type (Insert, Update, Delete, SCD Update, SCD Delete).

  • Filter by User (Account Name): Filter transactions based on who initiated them.

  • Filter by Table Name: Filter transactions based on the table name where they were performed.

  • Filter by Source Name: Filter transactions based on the data source.

  • Status: Filter transactions based on their status (success or failure). You'll find this under the 'More' option.

Under the 'More' option, you'll have two more filters, as below:

  • Start time: Filter transactions within a specific date range.

  • Job Type: Filter transactions by job type, whether they are direct transactions or have gone through an approval flow.

Remove Filter: To remove a specific filter, select the 'Clear' option from the relevant selection dropdowns. To clear all filters, select the Reset All option.

3. Export transaction Logs

You can export and download the transaction logs to an Excel or CSV file.

  1. Click on the Export option.

  1. Choose the file type you want to export and the logs' date range.

  1. Click on Export and then Download to download the file.

4. General details

When you click on a specific transaction/job, you will be taken to a page with detailed information about the transaction, as shown below.

You'll also be able to view the completed milestones in the transaction.

Milestone: A milestone represents the stages of the job's progress. It is divided into levels, with each level giving the user a clear indication of the job's advancement. Within each level, there are multiple events or sub-milestones.

Sub-milestones: These are a collection of smaller activities or tasks that, when completed, help to achieve an individual milestone. The sub-milestones help to break down larger milestones into more manageable steps, allowing for more detailed progress tracking while still contributing to the overall goal.

Let's take an example where we track the status and progress of the initiated transaction.

In case of failed transactions, the above details help in understanding in which stage the issue actually occurred.

5. Error details

For failed jobs, an additional tab called 'Error Details' becomes available. This section includes information about the errors that occurred during the job run.

This page has search and filter capabilities similar to any log, allowing you to find and filter specific error details.

You can copy the error message using the one-click copy option or download the error log by clicking Download Logs.

Transaction logs
Search by Transaction ID
Filter by transaction type
Filter by user
Filter by table
Filter by data source
Filter by status
Filter by date range
Filter by job type
Export
File type and date range
Export and download
General information
Milestones and events
Error Details
Search and filter errors
Download log or copy error message