The YouTube Query Model doesn't include some of the key core video metrics that YouTube API offers. https://developers.google.com/youtube/reporting/v1/reports/metrics#Watch_Time_Metrics
It looks like this is because Matillion is using the CData JDBC driver which doesn't include the missing core metrics in their driver. But it also looks like the last time it was updated was 2017. Do we know if the next version will include these core metrics that are currently missing? http://cdn.cdata.com/help/CGC/jdbc/pg_table-videos.htm
1 Community Answers
Veronica Kupetz —
Thanks for reaching out. I can put in that request with our Product/Development team in regards to having those core video metrics exposed. Based on the data model provided by cdata, I’m assuming this is not updated in the latest release. Have you been able to write a custom SQL query in “Advanced” mode to achieve this? I’m assuming it is not accessible based on the data model, but thought I’d mention. Another option is to create a custom API connection via Project —> Manage API Profiles and then use the API Query Component to access that API Profile. Here is a link to information regarding setting up API Profiles.