> For clean Markdown of any page, append .md to the page URL. > For a complete documentation index, see https://help.sigmacomputing.com/llms.txt. > For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server. # Example representation: Report with a paginated table (Beta) > Example Sigma code representation of a report with a paginated table. This documentation describes one or more public beta features that are in development. Beta features are subject to quick, iterative changes; therefore the current user experience in the Sigma service can differ from the information provided in this page. This page should not be considered official published documentation until Sigma removes this notice and the beta flag on the corresponding feature(s) in the Sigma service. For the full beta feature disclaimer, see [Beta features](/docs/sigma-product-releases#beta-features). This is an example representation of a report, retrieved using the [Get a report](/reference/get-report) endpoint with the query parameter `includeContents=true`. Representations like this one can be used to create a report from code using the [Create a report](/reference/create-report) endpoint. Each page in this example library includes the code representation of the report and step-by-step instructions to create it in the Sigma UI. Consult this example and others in the [Report representation example library](/docs/report-representation-example-library) to: * Troubleshoot the formatting of a particular feature in code representation * Relate a feature from the Sigma UI to its representation in code * Provide context to AI tools used to create reports from code This example representation cannot be used as-is. All identifying details, such as IDs, names, and URLs, have been replaced with randomized ID values or generic substitutions. The format of these contents, like the length of ID values, is preserved for demonstrative purposes. However, this representation cannot be directly used without modification to the base URL, connection details, and more. For more information, see [Create and manage reports from code](/docs/manage-reports-as-code). ## System and user requirements To complete the steps in this example, you must meet the user requirements listed below for creating the report in the UI and creating it from code. The ability to create this report in the Sigma UI requires the following: * You must be assigned an [account type](/docs/account-type-and-license-overview) with the **Create, edit, and publish reports** permission enabled. * You must have access to a connection to a data platform. The ability to create a report from code requires the following: * You must be assigned an [account type](/docs/account-type-and-license-overview) with the **Create, edit, and publish reports** permission enabled. * You must have developer credentials for the Sigma API. For more information, see [Get started with the Sigma REST API](/reference/get-started-sigma-api). This example uses a table from the [Sigma Sample Connection](/docs/sigmas-sample-connection). Your organization might have disabled access to the Sigma sample connection. If so, you can contact an admin to enable it, or use a table from another connection to follow along with this example. ## Create the example report in the Sigma UI This example shows a report with a paginated table. To create this report in the Sigma UI: 1. Go to the **Home** page. 2. Select ![](https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/button-add.svg) **Create new** > **Report**. A new report opens. 3. From the **Add element** bar, select **Data** > **Table**. 4. In the **Select source** modal, search for the table `PLUGS_ELECTRONICS_HANDS_ON_LAB_DATA` in the `EXAMPLES.PLUGS_ELECTRONICS` schema. 5. Select the table to add it to the report. 6. Add a filter to the table to only view data from the city of Portland: 1. Select **Filters** (![](https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/filter.svg)) in the element toolbar. 2. Select **Add filter...** to add a new filter. 3. Search for and select the **Store City** column. 4. Search for and select **Portland**. 7. Add a filter to the table to only view data for purchases from **SiriusXM**: 1. Select **Filters** (![](https://sigma-docs-screenshots.s3.us-west-2.amazonaws.com/Icons/filter.svg)) in the element toolbar. 2. Select **Add filter...** to add a new filter. 3. Search for and select the **Brand** column. 4. Search for and select **SiriusXM**. 8. At the lower right corner of the table, select **Expand table**. 9. In the document header, select **Save as**. 10. Enter a name for the report, such as `paginated-table`. 11. Select **Save**. ## Get a code representation of this report To get a representation of this report, follow the steps in [Get the code representation of a report](/docs/get-the-code-representation-of-a-report). The code representation of this report appears like the following: #### YAML representation ```yaml reportId: 3da2672a-e834-4a3d-b73f-8059d70d1147 reportUrlId: lyxteP97MCLMfFI25mCLU7 createdBy: UWCrlXH5OZPIvkmpaeAMF2oY3Y2dQ updatedBy: wAj3rAPRQ7VNx4vU2IaXXBv0x6YEk createdAt: '2026-09-03T17:44:34.372Z' updatedAt: '2026-09-03T17:58:18.873Z' name: paginated-table url: https://aws-api.sigmacomputing.com/org-name/report/lyxteP97MCLMfFI25mCLU7 path: My Documents/ latestVersion: 2 ownerId: UWCrlXH5OZPIvkmpaeAMF2oY3Y2dQ isArchived: false contents: schemaVersion: 1 elements: - id: jXVN47ruNw kind: table source: connectionId: 260797d8-7d5c-4ef2-8b11-18aee5513a25 kind: warehouse-table path: - EXAMPLES - PLUGS_ELECTRONICS - PLUGS_ELECTRONICS_HANDS_ON_LAB_DATA columns: - id: inode-Ke4QqA3Te8jlhdPge0IjdD/ORDER_NUMBER formula: '[PLUGS_ELECTRONICS_HANDS_ON_LAB_DATA/Order Number]' - id: inode-Ke4QqA3Te8jlhdPge0IjdD/DATE formula: '[PLUGS_ELECTRONICS_HANDS_ON_LAB_DATA/Date]' - id: inode-Ke4QqA3Te8jlhdPge0IjdD/SKU_NUMBER formula: '[PLUGS_ELECTRONICS_HANDS_ON_LAB_DATA/Sku Number]' - id: inode-Ke4QqA3Te8jlhdPge0IjdD/QUANTITY formula: '[PLUGS_ELECTRONICS_HANDS_ON_LAB_DATA/Quantity]' - id: inode-Ke4QqA3Te8jlhdPge0IjdD/COST formula: '[PLUGS_ELECTRONICS_HANDS_ON_LAB_DATA/Cost]' - id: inode-Ke4QqA3Te8jlhdPge0IjdD/PRICE formula: '[PLUGS_ELECTRONICS_HANDS_ON_LAB_DATA/Price]' - id: inode-Ke4QqA3Te8jlhdPge0IjdD/PRODUCT_TYPE formula: '[PLUGS_ELECTRONICS_HANDS_ON_LAB_DATA/Product Type]' - id: inode-Ke4QqA3Te8jlhdPge0IjdD/PRODUCT_FAMILY formula: '[PLUGS_ELECTRONICS_HANDS_ON_LAB_DATA/Product Family]' - id: inode-Ke4QqA3Te8jlhdPge0IjdD/PRODUCT_LINE formula: '[PLUGS_ELECTRONICS_HANDS_ON_LAB_DATA/Product Line]' - id: inode-Ke4QqA3Te8jlhdPge0IjdD/BRAND formula: '[PLUGS_ELECTRONICS_HANDS_ON_LAB_DATA/Brand]' - id: inode-Ke4QqA3Te8jlhdPge0IjdD/PRODUCT_NAME formula: '[PLUGS_ELECTRONICS_HANDS_ON_LAB_DATA/Product Name]' - id: inode-Ke4QqA3Te8jlhdPge0IjdD/STORE_NAME formula: '[PLUGS_ELECTRONICS_HANDS_ON_LAB_DATA/Store Name]' - id: inode-Ke4QqA3Te8jlhdPge0IjdD/STORE_KEY formula: '[PLUGS_ELECTRONICS_HANDS_ON_LAB_DATA/Store Key]' - id: inode-Ke4QqA3Te8jlhdPge0IjdD/STORE_REGION formula: '[PLUGS_ELECTRONICS_HANDS_ON_LAB_DATA/Store Region]' - id: inode-Ke4QqA3Te8jlhdPge0IjdD/STORE_STATE formula: '[PLUGS_ELECTRONICS_HANDS_ON_LAB_DATA/Store State]' - id: inode-Ke4QqA3Te8jlhdPge0IjdD/STORE_CITY formula: '[PLUGS_ELECTRONICS_HANDS_ON_LAB_DATA/Store City]' - id: inode-Ke4QqA3Te8jlhdPge0IjdD/STORE_ZIP_CODE formula: '[PLUGS_ELECTRONICS_HANDS_ON_LAB_DATA/Store Zip Code]' - id: inode-Ke4QqA3Te8jlhdPge0IjdD/STORE_LATITUDE formula: '[PLUGS_ELECTRONICS_HANDS_ON_LAB_DATA/Store Latitude]' - id: inode-Ke4QqA3Te8jlhdPge0IjdD/STORE_LONGITUDE formula: '[PLUGS_ELECTRONICS_HANDS_ON_LAB_DATA/Store Longitude]' - id: inode-Ke4QqA3Te8jlhdPge0IjdD/CUST_KEY formula: '[PLUGS_ELECTRONICS_HANDS_ON_LAB_DATA/Cust Key]' - id: inode-Ke4QqA3Te8jlhdPge0IjdD/CUSTOMER_NAME formula: '[PLUGS_ELECTRONICS_HANDS_ON_LAB_DATA/Customer Name]' - id: inode-Ke4QqA3Te8jlhdPge0IjdD/CUST_JSON formula: '[PLUGS_ELECTRONICS_HANDS_ON_LAB_DATA/Cust Json]' filters: - id: dKRnBhPONe columnId: inode-Ke4QqA3Te8jlhdPge0IjdD/STORE_CITY kind: list mode: include values: [] - id: 0eBmrbqaSG columnId: inode-Ke4QqA3Te8jlhdPge0IjdD/BRAND kind: list mode: include values: - SiriusXM order: - inode-Ke4QqA3Te8jlhdPge0IjdD/ORDER_NUMBER - inode-Ke4QqA3Te8jlhdPge0IjdD/DATE - inode-Ke4QqA3Te8jlhdPge0IjdD/SKU_NUMBER - inode-Ke4QqA3Te8jlhdPge0IjdD/QUANTITY - inode-Ke4QqA3Te8jlhdPge0IjdD/COST - inode-Ke4QqA3Te8jlhdPge0IjdD/PRICE - inode-Ke4QqA3Te8jlhdPge0IjdD/PRODUCT_TYPE - inode-Ke4QqA3Te8jlhdPge0IjdD/PRODUCT_FAMILY - inode-Ke4QqA3Te8jlhdPge0IjdD/PRODUCT_LINE - inode-Ke4QqA3Te8jlhdPge0IjdD/BRAND - inode-Ke4QqA3Te8jlhdPge0IjdD/PRODUCT_NAME - inode-Ke4QqA3Te8jlhdPge0IjdD/STORE_NAME - inode-Ke4QqA3Te8jlhdPge0IjdD/STORE_KEY - inode-Ke4QqA3Te8jlhdPge0IjdD/STORE_REGION - inode-Ke4QqA3Te8jlhdPge0IjdD/STORE_STATE - inode-Ke4QqA3Te8jlhdPge0IjdD/STORE_CITY - inode-Ke4QqA3Te8jlhdPge0IjdD/STORE_ZIP_CODE - inode-Ke4QqA3Te8jlhdPge0IjdD/STORE_LATITUDE - inode-Ke4QqA3Te8jlhdPge0IjdD/STORE_LONGITUDE - inode-Ke4QqA3Te8jlhdPge0IjdD/CUST_KEY - inode-Ke4QqA3Te8jlhdPge0IjdD/CUSTOMER_NAME - inode-Ke4QqA3Te8jlhdPge0IjdD/CUST_JSON pages: - id: tBjXFZQFK0 name: .default config: margin: 0 pageHeight: 1056 pageWidth: 816 kind: report layout: | documentVersion: 2 ``` ## Representing paginated tables #### Paginated table representation ```yaml ... layout: | ... ```