PropertiesDataStreams
Lists all data streams under a property to which the user has access. Attribute Parent (e.g: 'properties/123') or Name (e.g: 'properties/123/webDataStreams/456') is required to query the table.
Select
The connector uses the Google Analytics API to process WHERE clause conditions built with the following columns and operators:
- Parent supports the following operator: =
- Name supports the following operator: =
SELECT * FROM PropertiesDataStreams WHERE Parent = 'properties/123' SELECT * FROM PropertiesDataStreams WHERE Name = 'properties/123/webDataStreams/456'The rest of the filter is executed client-side in the connector.
Columns
Name | Type | Dimension | DefaultMetric | DefaultDimension | Description |
CreateTime | Datetime | Time the stream was created. | |||
DisplayName | String | Display name for the data stream. | |||
Name | String | Web data stream name. | |||
Parent | String | Name of the web data stream's logical parent. | |||
Type | String | Name of the web data stream's logical parent. | |||
webStreamData | String | Data specific to web streams. | |||
androidAppStreamData | String | Data specific to Android app streams. | |||
iosAppStreamData | String | Data specific to iOS app streams. | |||
UpdateTime | Datetime | Time the stream was last modified. | |||
PropertyId | Integer | The Property Id value to be used when querying this table. |