The UI provides these four options: and or custom cron. Under Schedule, you can choose when and how often you want to run this query. Select the Timezone for your data storage. As a default time column, it uses upload_time with the add_time filter. If you want to set a different partition key seed than the default key, you can specify the long or timestamp column as the partitioning time. Select the Timestamp-based Partition Key column. Replace on New Data-Only replace the entire content of an existing table with the result output when there is new data. If the table does not exist, a new table is created. If the table does not exist, it will be created.Īlways Replace-Replaces the entire content of an existing table with the result output of the query. Select a Table> Select an existing or Create New Table.Ĭhoose the method for importing the data.Īppend (default)-Data import results are appended to the table. Select a Database > Select an existing or Create New Database. Under Storage you will create a new or select an existing database and create a new or select an existing table for where you want to place the imported data.
![pentaho data integration youtube pentaho data integration youtube](https://s1.manualzz.com/store/data/037742129_1-d87f21aabe2b5d642cb4ae9c9e0486e0-360x466.png)
Verify that the data looks approximately like you expect it to.įor data placement, select the target database and table where you want your data placed and indicate how often the import should run. To preview your data, select Generate Preview. It is not the actual data that is imported.ĭata preview is optional and you can safely skip to the next page of the dialog if you want. You can see a preview of your data before running the import by selecting Generate Preview.ĭata shown in the data preview is approximated from your source. For example, if the initial config is January 1, fetched until January 15 with ten days in duration, the first run fetches data modified from January 1 to January 15, the second run fetches from January 16 to January 25, and so on. Incremental: When running on schedule, the time window of the fetched data automatically shifts forward on each run. Load from published date: The earliest published date of the specified Report Type becomes the start date to retrieve analytics.īegin date: The start date to retrieve analytics (either "Load from published date" or "Begin date" need to be specified).Įnd date: The end date to retrieve analytics (inclusive).Īggregation Period (Day): The number of days to group each record of the analytics.ĭuration (Day): The number of days to retrieve analytics from the current end date in the next incremental run. This parameter is not mandatory for non-Content Owner reports. Include Historical Channel Data: Specify whether the YouTube Analytics API returns the historical analytics for the channel before joining the Content Owner. This parameter is only mandatory for some specific reports. Sort: The metrics to sort the analytics result from the API. This parameter is only mandatory for some specific reports, otherwise, leave it blank to retrieve all analytics. Max Results: The number of analytics records for the API to return. This parameter is only available for Videos report presets.ĭimensions: A list of Analytics dimensionsįilters: A list of filters (this parameter only appears in some presets) Playlists: playlist IDs to filter the list of videos. Report Presets: The collection of dimensions, metrics, and filters. Report Type: The expected target of the analytics: video, playlist, or channels. For non-partner YouTube accounts, leave this blank. Otherwise, leave this as blank.Ĭhannel IDs: The list of Channel IDs under the management of the Content Owner. Otherwise, leave the parameters empty.Ĭhoose the Report Type (Video, Playlist, or Channel), and choose the report preset.ĬMS ID: CMS ID of the YouTube account, if participating in the YouTube Partner Program. Provide your account CMS ID and Channel IDs if you participate in the program. Click Done.Ĭlick New Source from the saved authentications If you choose OAuth, select an existing OAuth connection, or click Click Here to connect a new account.Ĭlick Continue. OAuth refresh_token: the refresh_token for your account that allows all scopes for the custom OAuth app.
![pentaho data integration youtube pentaho data integration youtube](https://i.ytimg.com/vi/EHhs9NAzu6I/hq720.jpg)
OAuth client_secret: the client_secret for the custom OAuth app set up on Google Console. OAuth client_id: the client_id for the custom OAuth app set up on Google Console.
![pentaho data integration youtube pentaho data integration youtube](https://i.ytimg.com/vi/N_o2dS8oP9E/hqdefault.jpg)
If you choose Your custom OAuth app, provide the following parameters: See this Q&A Section for more information.
![pentaho data integration youtube pentaho data integration youtube](https://i.ytimg.com/vi/fqMzUVs3DuI/maxresdefault.jpg)
Your custom OAuth app is the preferable mode.