Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

YouTube Data Model Missing Core Metrics

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

Matillion Agent  

Veronica Kupetz —

Hi Donna,

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.

Best Regards,
Veronica

Post Your Community Answer

To add an answer please login