JDBC Driver for Google Analytics

Build 22.0.8509

Properties

Lists all Properties to which the user has access.

Table Specific Information

Select

The provider will use the GoogleAnalytics4 API to process WHERE clause conditions built with the following columns and operators: The rest of the filter is executed client-side within the provider.

  • Parent supports the following operators: =,IN
  • Id supports the following operators: =,IN
The following queries are processed server-side:
   	SELECT * FROM Properties WHERE Id = '54516992'
    SELECT * FROM Properties WHERE Parent = 'accounts/54516992'

You can turn off client-side execution by setting SupportEnhancedSQL to false, in which case any search criteria that refers to other columns will cause an error.

Columns

Name Type ReadOnly Description
CreateTime Datetime True

Time the property was created.

CurrencyCode String True

The currency type used in reports involving monetary values.

DisplayName String True

Display name for the property.

IndustryCategory String True

Industry associated with the property.

Id Integer True

Property Id.

Parent String True

Name of the property's logical parent.

TimeZone String True

Reporting Time Zone.

UpdateTime Datetime True

Time the property was last modified.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8509