Tables
This section displays a list of tables configured in the PowerTable visual on the left pane and their corresponding configuration details on the right side when clicked on each one of them.
Use the search box to quickly search for the required table.
Upon selecting a specific table, the user can view three main items corresponding to that table: general details, approvals, and transaction logs.
General
This page shows the column and connection details of the table.
Columns: This section contains information about the columns in the table, such as column names, their data type, default values if they are configured, null/not-null property, any set constraints, relation, etc.
Connection Details: The following connection details can be seen from this section:
Connection Type: The type of connection (e.g., Fabric Warehouse, Azure SQL, Snowflake, BigQuery, etc.).
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 published reports that use this connection and table, with their URL.
Approvals
This page lists all approvals related to transactions involving the particular table. Here, you can track each approval's status and complete details of the request, such as the ID, requested user, approvers, created time, and reviewed time.
Search: You can search for specific approval requests using the search option.
Filter: You also have the option to filter approvals based on the requested user, status, approver, requested time, and reviewed time.
Transaction logs
This tab logs all transactions made to the selected table and provides a historical record of changes for auditing and tracking purposes. 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.
Search for a transaction using the search option.
Filter transactions using the ID, transaction type, user's name, status, start time, and the job type.
Click on any transaction ID to view detailed information about the transaction.
Last updated