How do I get more than 200 000 rows in a Data Query export?

Exports in .csv format from Data Query are limited to 200,000 rows by default.

If you purchased the Data Flow option, this limit is automatically increased to 1,000,000 rows for Data Query exports.

Important: API row limit (cannot be exceeded)

The Data Query API is limited to 200,000 rows per request, and this limit cannot be bypassed, even when using pagination (for example, retrieving 10,000 rows per page).

Pagination is still useful to retrieve results up to the limit (typically max-results=10000 over up to 20 pages), but it will not allow you to go beyond 200,000 rows for a single request.

How to export more than 200,000 rows without additional options

If you do not have an export extension option enabled, you can export more than 200,000 rows by splitting your extraction into multiple queries, for example by:

Cutting your analysis period into smaller date ranges (day by day, week by week, etc.)
Using a more granular time filter (commonly the Hour dimension/property) to export a subset of the day (e.g., hours 0–8, then 9–17, then 18–23)

After downloading each file, you can combine the CSVs in your preferred tool (Excel, a database, or an ETL process).

Paid options for large-scale exports

For regular or very large exports, Piano offers products designed for massive data extraction:

Data Flow: Introduction & Data Schema
Designed for recurring, high-volume exports of granular (near-raw) data to destinations such as FTP, Amazon S3, or Google Cloud Storage. This data typically requires downstream processing in your own environment.
Data Sharing: Introduction, Data Schema & Access
Provides direct access to the underlying database (Snowflake) so you can query data with SQL in your own workflows.
Premium Data Query exports:
A paid option that removes the row limit for Data Query file exports (typically CSV, sometimes delivered as a compressed export). This option does not remove the 200,000-row cap for API requests, but it enables Hourly Data Query exports.

All options mentioned here are paid options. Contact your Account Manager or our Support Centre to confirm availability in your contract, pricing, and activation steps.