The Data Prep (Paxata) documentation is now available on the DataRobot public documentation site. See the Data Prep section for user documentation and connector information. After the 2021.2 SP1 release, the content on this site will be removed and replaced with a link to the DataRobot public documentation site.
User Persona: Paxata User - Paxata Admin - Data Source Admin
*Note: This document covers all configuration fields available during Connector setup. Some fields may have already been filled out by your Admin at an earlier step of configuration and may not be visible to you. For more information on Paxata’s Connector Framework, please see here.
Also: Your Admin may have named this Connector something else in the list of Data Sources.
This connector allows you to connect to Google Analytics for browsing and importing available data. The following parameters are used to configure the connection.
Name: Name of the data source as it will appear to users in the UI.
Description: Description of the data source as it will appear to users in the UI.
Something to consider: You may connect Paxata to multiple Google Analytics Accounts and having a descriptive name can be a big help to users in identifying the appropriate data source.
Google Analytics Configuration
OAuth Verifier Key: The verifier key used to authenticate with Google Analytics. To obtain the verifier key, click ''Test Data Source'' and follow the link to grant access to Google Analytics. After allowing access, you will be redirected to a page that displays an access code. Copy the code into this field.
Profile: The Google Analytics profile or view to connect to. This can be set to either the Id or website URL for the profile.
Select the web proxy options for connecting to Google Analytics.
Web Proxy: 'None' if no proxy is required or 'Proxied' if the connection to Google Analytics should be made via a proxy server. If a web proxy server is required, the following fields are required to enable a proxied connection.
Proxy Host: The hostname or IP address of the proxy server.
Proxy Port: The port of the proxy server.
Proxy Username and Proxy Password: User credentials for an authenticated proxy connection. Leave these blank for an unauthenticated proxy connection.
Data Import Information
Browse a list of pre-defined datasets in Google Analytics and select a dataset, click Select for import.
Accounts: Lists all Accounts to which the user has access.
The default behavior of the CData JDBC Driver is to retrieve data for the last 7 days. In order to customize the time window you can set the StartDate and EndDate values in your query directly. The supported inputs for StartDate and EndDate in the Google Analytics API are 'today', 'yesterday', 'NdaysAgo' (where N is some number), and an exact date.
SELECT * FROM Traffic WHERE StartDate='2020-01-01' AND EndDate='5daysAgo'