Connect Youtube to Snowflake

youtube
+
snowflake

Stream marketing data from Youtube to Snowflake

Connect Youtube to Snowflake in 2023

It is very simple to connect Youtube to Snowflake, it can be done in a fast and easy manner with Windsor.ai.

 

First Step

Follow the Tutorial Below:

  1. Add all the columns that are returned by your connector’s URL. 
  2. Create the WINDSOR_UPLOAD role (name has no importance) 
  3. Create a user and add the previously created role to that user 
  4. Grant rights to the DATABASE to the created user 
  5. Grand the rights to the destination table 
  6. Get the required fields from Snowflake to use the Snowflake destination in Onboard Form
  • Get the username 
  • Get the password 
  • Get the account 
  • Get the warehouse 
  • Get the database 
  • Get the schema 
  • Get the table name 

 

Second step

1. You need to select Youtube as a Data Source and Grant Access to Windsor.ai.

youtube integration

 

2. In Select Destination select Snowflake as destination

snowflake integration

 

3. Enter all the credentials required and click Save

 

4. Your data will now be streamed from Youtube to Snowflake. In case there is an error you will be notified.

Youtube metrics and dimensions available for streaming into Snowflake

Connect your data

nametypedescription
Annotation Click Through RateNUMERICThe ratio of annotations that viewers clicked to the total number of clickable annotation impressions.
Annotation Clickable ImpressionsNUMERICThe number of annotations that appeared and could be clicked.
Annotation ClicksNUMERICThe number of clicked annotations.
Annotation Closable ImpressionsNUMERICThe number of annotations that appeared and could be closed.
Annotation Close RateNUMERICThe ratio of annotations that viewers closed to the total number of annotation impressions.
Annotation ClosesNUMERICThe number of closed annotations.
Annotation ImpressionsNUMERICThe total number of annotation impressions.
Average View DurationNUMERICThe average length, in seconds, of video playbacks.
Average View PercentagePERCENTThe average percentage of a video watched during a video playback.
Card Click RatePERCENTThe click-through-rate for cards, which is calculated as the ratio of card clicks to card impressions.
Card ClicksNUMERICThe number of times that cards were clicked.
Card ImpressionsNUMERICThe number of times cards were displayed. When the card panel is opened, a card impression is logged for each of the video's cards.
Card Teaser Click RatePERCENTThe click-through-rate for card teasers, which is calculated as the ratio of clicks on card teasers to the total number of card teaser impressions.
Card Teaser ClicksNUMERICThe number of clicks on card teasers. Card icon clicks are attributed to the last teaser displayed to the user.
Card Teaser ImpressionsNUMERICThe number of times that card teasers were displayed. A video view can generate multiple teaser impressions.
Channel IDTEXTThe ID that YouTube uses to uniquely identify the channel that the video was uploaded to.
Channel image URL (default)IMAGE_URLThumbnail image URL associated with the channel
Channel titleTEXTThe channel's title.
CommentsNUMERICThe number of times that users commented on a video.
DateDATEDate of reported values.
DislikesNUMERICThe number of times that users indicated that they disliked a video by giving it a negative rating.
Estimated Minutes WatchedNUMERICThe number of minutes that users watched videos for the specified channel, content owner, video, or playlist.
Estimated Red Minutes WatchedNUMERICThe number of minutes that YouTube Premium (previously known as YouTube Red) members watched a video.
LikesNUMERICThe number of times that users indicated that they liked a video by giving it a positive rating.
The video's privacy status.TEXTThe video's privacy status.
Publish dateDATEThe date and time that the video was published. Note that this time might be different than the time that the video was uploaded.
Red ViewsNUMERICThe number of times that a video was viewed by YouTube Premium (previously known as YouTube Red) members.
SharesNUMERICThe number of times that users shared a video through the Share button.
Channel subscriber countNUMERICThe number of subscribers that the channel has.
Subscribers GainedNUMERICThe number of times that users subscribed to a channel.
Subscribers LostNUMERICThe number of times that users unsubscribed from a channel.
VideoOBJECTStatistics broken down by videos in the channel.
Video age restrictionTEXTA rating that YouTube uses to identify age-restricted content.
Video categoryTEXTThe YouTube video category associated with the video.
Channel video countNUMERICThe number of public videos uploaded to the channel.
Video descriptionTEXTThe video's description.
Video has captionsBOOLEANIndicates whether captions are available for the video.
Video lengthTEXTThe length of the video.
Video is licensed contentBOOLEANIndicates whether the video represents licensed content, which means that the content was uploaded to a channel linked to a YouTube content partner and then claimed by that partner.
Video resolutionTEXTIndicates whether the video is available in high definition (HD) or only in standard definition.
Video tagsTEXTA list of keyword tags associated with the video.
Video titleTEXTThe video title
Video image URL (default)IMAGE_URLThumbnail image URL associated with the video
Videos Added To PlaylistsNUMERICThe number of times that videos were added to any YouTube playlists. The videos could have been added to the video owner's playlist or to other channels' playlists.
Videos Removed From PlaylistsNUMERICThe number of times that videos were removed from any YouTube playlists. The videos could have been removed from the video owner's playlist or from other channels' playlists.
Full Video URLTEXTFull URL of the video
YouTube Video ViewsNUMERICThe number of times that a video was viewed.
TodayDATEToday's date

Easily connect Youtube to Snowflake

See the value and return on every marketing touchpoint

data warehouse

Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketers, whenever they want.

insights

Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.

Build your Youtube and Snowflake Integrations