Data Source Name
A unique name for this Data Source definition.
Note: Names can contain only alphanumeric characters and underscores.
A description of this set of connection parameters.
OAuth Profile Name
In some environments, you might want to reuse connections for users who have different access privileges. You can create separate profiles for different users.
Select an OAuth profile name from the drop-down list, or create a new profile by clicking Create New Profile in the dropdown list, entering a profile name, and then clicking the Add icon. Then, click Authorize with Google.
When you select an OAuth Profile Name that has been authorized with Google, the Default View Name and Segment fields get populated.
Default View Name
A view that belongs to your Google Analytics account. Select a view from the drop-down list.
A segment that belongs to your Google Analytics account. Select a segment from the drop-down list.
The start date for fetching Google Analytics data (inclusive). You can enter a specific date in YYYY-MM-DD format, or select a date, using the calendar icon. Alternatively, select a relative value (Today, Yesterday, or N Days Ago, where N is a positive integer). The default is 30 days prior to the current date.
The end date for fetching Google Analytics data. You can enter a specific date in YYYY-MM-DD format, or select a date, using the calendar icon. Alternatively, select a relative value from the drop-down list (Today, Yesterday, or N Days Ago, where N is a positive integer).
The end date must always be later than the start date, if a start date is specified.
Optional name of the map definition that Hybrid Data Pipeline uses to interpret the schema of the data store. The Hybrid Data Pipeline service automatically creates a name for the map. If you want to name the map yourself, enter a unique name.
Specifies whether the connectivity service attempts to refresh the schema when an application first connects.
When the check box is selected (set to true), the connectivity service attempts to refresh the schema.
When the check box is not selected (set to false), the connectivity service does not attempt to refresh the schema.
Determines whether the Google Analytics table mapping files are to be (re)created.
Hybrid Data Pipeline automatically maps data store objects and fields to tables and columns the first time that it connects to the data store. The map includes both standard and custom objects and includes any relationships defined between objects.
A set of tables to work with your Google Analytics account.
To create configuration tables that use different combinations of Metrics and Dimensions, click the Configure Logical Schema button.
In the Configure Logical Schema screen, click Create Table and enter a name for the table.
In the Dimensions and Metrics screen, select the metrics that you want to add to the table. You can select metrics across multiple dimensions. Each metric gets added as a column in the table.
Finally, click Save & Close.
Show Deprecated Objects
Defines whether Hybrid Data Pipeline shows deprecated objects. Google Analytics marks dimensions and metrics as deprecated as an indication that they plan to remove support for those objects. By default, the Hybrid Data Pipeline connectivity service does not expose these deprecated objects. Set the value to true while you work on rewriting your queries and table definitions to migrate from the deprecated objects. Once the queries and table definitions are fixed, change the setting for the map option back to false.
true | false
If the check box is selected (true), Hybrid Data Pipeline includes deprecated objects in the relational model.
If the check box is not selected (false), Hybrid Data Pipeline does not include deprecated objects in the relational model.
Show Internal Tables
Defines how Hybrid Data Pipeline shows internal tables.
true | false
If the check box is selected (true), Hybrid Data Pipeline shows the "Data" table.
If the check box is not selected (false), Hybrid Data Pipeline does not show the "Data" table.
Defines a comma-separated list of tables that should be hidden from the user's view. This feature is useful if you want to define your own tables instead of using some of the tables that are supplied with the data store, or to limit access to certain tables so that the user does not see them. For example, enter adSense,adWords.
subtractTables can be used both for the pseudo-tables in Google Analytics that are derived from the Data system table, and also for the regular management tables such as Goal or Account.