JDBC Driver for Shopify

Build 25.0.9434

ShowAggregate

Specifies whether the provider includes aggregate values in the result set and how they are structured.

Possible Values

None, PageSize

Data Type

string

Default Value

"None"

Remarks

This property controls whether the driver appends aggregate values, such as totals or group-level summaries to the result set, and how those values are aligned with the output.

  • None: The driver does not include any aggregate values in the result set.
  • PageSize: The driver includes aggregates and repeats or pads them to match the number of rows returned per page. This can be helpful when aligning totals with paged data for frontend display or data processing logic.

This property is useful when consuming paged data and needing consistent row alignment between raw data and aggregate metrics.

Enabling aggregation may increase processing time slightly, especially when working with large datasets and paging. Use this setting only when you need structured aggregation output.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434