This property enhances SQL functionality beyond what can be supported through the API directly, by enabling in-memory client-side processing.

Syntax

Connect-GAnalytics -SupportEnhancedSQL bool

Data Type

bool

Default Value

true

Remarks

When SupportEnhancedSQL = true, the 本製品 offloads as much of the SELECT statement processing as possible to Google Analytics and then processes the rest of the query in memory. In this way, the 本製品 can execute unsupported predicates, joins, and aggregation.

When SupportEnhancedSQL = false, the 本製品 limits SQL execution to what is supported by the Google Analytics API.

Execution of Predicates

The 本製品 determines which of the clauses are supported by the data source and then pushes them to the source to get the smallest superset of rows that would satisfy the query. It then filters the rest of the rows locally. The filter operation is streamed, which enables the 本製品 to filter effectively for even very large datasets.

Execution of Joins

The 本製品 uses various techniques to join in memory. The 本製品 trades off memory utilization against the requirement of reading the same table more than once.

Execution of Aggregates

The 本製品 retrieves all rows necessary to process the aggregation in memory.

When SupportEnhancedSQL = true, the 本製品 offloads as much of the SELECT statement processing as possible to Google Analytics and then processes the rest of the query in memory. In this way, the 本製品 can execute unsupported predicates, joins, and aggregation.

When SupportEnhancedSQL = false, the 本製品 limits SQL execution to what is supported by the Google Analytics API.

Execution of Predicates

The 本製品 determines which of the clauses are supported by the data source and then pushes them to the source to get the smallest superset of rows that would satisfy the query. It then filters the rest of the rows locally. The filter operation is streamed, which enables the 本製品 to filter effectively for even very large datasets.

Execution of Joins

The 本製品 uses various techniques to join in memory. The 本製品 trades off memory utilization against the requirement of reading the same table more than once.

Execution of Aggregates

The 本製品 retrieves all rows necessary to process the aggregation in memory.