When I attempt to use the YouTube analytics connector, I get the same error every time. I have even brought it down to one single table and still get the same error when I try to build the data source.
Any ideas what I am doing wrong here? I have fully updated SiSense as well as the YouTube Analytics connector and still getting the same issue. When navigating directly to the Java file and Clicking Test Connection, I get Connection Successful.
Malformed SQL Statement: Unexpected token encountered: [Group].
Statement:select Channel,Video,Playlist,Group,Country,Province,Continent,SubContinent,IsCurated,ClaimedStatus,UploaderType,SubscribedStatus,YoutubeProduct,Views,EstimatedMinutesWatched,AverageViewDuration,AverageViewPercentage,PlaylistStarts,Likes,ViewerPercentage,Comments,Dislikes,Shares,SubscribersGained,SubscribersLost,VideosAddedToPlaylists,VideosRemovedFromPlaylists,ViewsPerPlaylistStart,AverageTimeInPlaylist,AnnotationImpressions,AnnotationClickableImpressions,AnnotationClicks,AnnotationClickThroughRate,AnnotationClosableImpressions,AnnotationCloses,AnnotationCloseRate,EstimatedRevenue,EstimatedAdRevenue,EstimatedRedPartnerRevenue,GrossRevenue,Cpm,AdImpressions,MonetizedPlaybacks,PlaybackBasedCpm,StartDate,EndDate from CData.YouTubeAnalytics.TopVideos limit 1
Please sign in to leave a comment.