Tables
The Table widget displays data from SQL queries in a structured, customizable format.
Adding a Table to Your Dashboard
To add a table widget to your dashboard:
- Open the dashboard where you want to add the table
- Click the + Add widget button in the top-left corner
- Select Table from the widget menu that appears
Once added, you can begin configuring your table.
Opening the Table Editor
Right-click on the Table widget and select Edit to open the editor panel on the right side of your screen.
Naming Your Table
Give your table a descriptive name by clicking the Name field and entering a meaningful title, such as "Pipeline Summary" or "Revenue Breakdown". The table name will update immediately in your dashboard view. You can also substitute a variable in this field, by using the Variable Substituion Syntax. This can be useful for dynamically naming your widget, often based on a selected filter.
Adding a Dataset
Before you can query your database, you must create a dataset for that query. Inside the dataset you will be able to add formatting rules, view metadata, and set other various settings. Note that a table can only have one Dataset, if you want to use more than one dataset, you will need to use a Matrix Object.
- Click + Dataset under the Spaces tab to create a new data source
- A dataset block will appear with a unique identifier (e.g.,
dataset_4nqop) - Rename the dataset to something meaningful for easy reference
SQL Queries
If you are unfamiliar with SQL, it might be worth it to look into the AWS SQL documentation
Click Edit Query to open the SQL editor where you can write or paste your query. The query defines what data will populate your table. Click outside the editor to save your changes, and the dataset will be ready to preview or refresh.
Una also leverages AI to help you create queries using plain language. You can use the text box underneath the query editor to create a query. You will be then given the option to copy, add, or replace the query the AI generated.
The test button will attempt to run the query, and show you a sample of the response.
Styling Your Table
There are many ways to customize the appearance of your table using the dataset editor panel:
- Preview: Set the number of rows to display by default
- Text & Background: Choose colors for text and background using the dropdown menus
- Alignment: Control how content is aligned within cells
- Font Weight: Toggle bold formatting as needed
Changes to styling will be reflected in the preview immediately. Find more information on styling here.
Building Your Table Structure
Add rows or columns to organize your data:
- Click + Row to add a new row, or switch the space type dropdown to Column for columnar layout
- Each new space receives a unique identifier (e.g.,
row_5vld5h) - Customize each row or column block by:
- Renaming for clarity
- Adjusting display formatting in the General section
- Applying background and text styles
- Setting content alignment
- Using grouping or styling templates when available
Using Triggers (Optional)
Switch to the Triggers tab to configure interactive behaviors or automated actions for your table.
Finalizing Your Table
Once you've configured your query, styling, and layout, refresh the widget to see your table populate with data. The content will load from your dataset query, and all rows, columns, and styling will render according to your specifications.