[how-to] Azure DW table pagination

[Kenny]

Azure DW does not allow using LIMIT and OFFSET, so instead you need to reference the range of “rowNumber”s that you would want to display

1. Get the total number of rows from the table

SELECT count(*)
FROM your_table

2. Enable server-side pagination for your table

• Pagination type: Limit offset based

3. Insert Total row count from your query in step 1: {{Math.round(total.data.count[0] / table1.paginationOffset)}}

4. Query your database using pagination:

SELECT * 
FROM your_table 
WHERE rowNumber > {{table1.paginationOffset}} and rowNumber < {{table1.paginationOffset + table1.pageSize}}