Tables

This section displays a list of tables configured in the EDITable visual on the left pane and their corresponding configuration details on the right side when clicked on each one of them.

Tables

Upon selecting a specific table, the user can view three main items corresponding to that table: general details, approvals, and transaction logs.

Table details

Use the search box to quickly search for the required table.

Search table

1. General

General tab

• Column Details: This section contains information about the columns in the table such as column names, their data types, default values, null/not-null property, constraints, relation, etc.).

• Connection Details: The connection details can be seen from this section:

  • Connection Type: The type of connection (e.g., Fabric Warehouse, Azure SQL, Snowflake, BigQueryetc.).

  • Account: Account information associated with the table.

  • Username: The user who created or manages the table.

  • Created At: Timestamp of when the table was created.

  • Updated At: Timestamp of the most recent update to the table.

  • Updated By: The user who last updated the table.

• Reports: This part lists all reports that use this connection and table.

2. Approvals

Approvals

1. You can view all approvals related to transactions involving the table.

2. Track each approval's status and complete details such as the requested user, approver, created time, and when it was reviewed.

3. Search specific approval requests using the search option.

4. Filter approvals based on the requested user, status, approver, requested time and reviewed time.

5. Download or delete the report by clicking on the options Download Report and Delete Report respectively.

3. Transaction Logs

1. This tab logs all transactions made to the table and provides a historical record of changes for auditing and tracking purposes.

2. You can view the complete details of every transaction, including the job ID, transaction type, number of rows affected, duration, status, the user’s name, and the time it was completed.

3. Search for a transaction using the search option.

4. Filter transactions using the ID, transaction type, user's name, status, start time and the job type.

5. Download or delete the report by clicking on the options Download Report and Delete Report respectively.

6. Click on any job ID to view detailed information about the transaction and the milestones with their respective duration and timestamps as below:

job details