[how-to] Azure DW table pagination

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
  1. Enable server-side pagination for your table
  • Pagination type: Limit offset based
  1. Insert Total row count from your query in step 1: {{Math.round(total.data.count[0] / table1.paginationOffset)}}

  2. Query your database using pagination:

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