Get started with Data Sharing

Data Sharing gives you access to video consumption insights that can help you better understand the performance of your videos. Leveraging Snowflake's Secure Data Sharing, Data Sharing provides a solution for retrieving granular data about JWP video playback which can be used for deeper analysis about user behavior and can be combined with data from complementary applications:

Streamlined Setup: Use of Snowflakes's secure data sharing capabilities eliminates the need to build an in-house solution query the JWP's Management API and manually create data tables.
Tool Compatibility: Data Sharing integrates with any data tools that allow a standard Snowflake connection from the Snowflake Ecosystem, such as leading business intelligence tools.
Deeper Insights: Access individual play sessions, additional metrics and dimensions, and control time ranges.

Set up Data Sharing

JWP offers two options for setting up Data Sharing. Each option is explain in the following sections.

Direct Snowflake Share

Use the following steps if you already have a Snowflake account:

Provide your Snowflake Account ID to your JWP representative. Your JWP representative will notify you when the data share is configured.
Accept the connection.

Basic Direct Share Connection Details

Role	`Public`
Database	`JW_DATA`
Schema	`Public`

Snowflake Reader Account

Use the following step if you do not have a Snowflake account:

Request Data Sharing credentials from your JWP representative. Your JWP representative will send you account setup information.
⚠️
If you request data sharing credentials from your JWP representative, you will receive a one-time setup link via email. Since this link expires within four hours, be sure to schedule a time to receive this email.

Basic Reader Account Connection Details

Hostname / Account URL	`https://jwplayer-reader_<jw_account_id>.snowflakecomputing.com/`
Warehouse	`MEDIUM`
Role	`Public`
Database	`JW_DATA`
Schema	`Public`

Reference

Data Access

The following table lists common use cases for JWP's Data Sharing product.

Approach	Notes
Direct Connection	Enables directly connecting to any data tools that allow a standard Snowflake connection from the Snowflake Ecosystem, such as leading business intelligence tools
Data Replication	Enables replicating data into a data warehouse, such as Redshift and BigQuery This can be a customer-built integration that queries the data at regular intervals or uses any data replication tool supporting a Snowflake connection.
Data Export	Enables bulk unloading of data from a database table into flat, delimited text files

Data Sets

Play Sessions

This dataset contains play sessions which are rows of data containing attributes that pertain to a specific user watching a specific video in a JWP cloud-hosted, JWP self-hosted, or JWP SDK player.

Item	Description
Table name	`JW_DATA.PUBLIC.PLAY_SESSIONS_<jw_account_id>;`
Number of data attributes	See: Data Sharing metrics and dimensions
New play session row creation	A new row is created when either of the following occurs: The video player advances to the next video, such as in a playlist. The user leaves the page.
User session generation	Linking all play sessions for a specific user during a visit provides an understanding of the viewer's user session.
Data refresh rate	Once per morning, US - Eastern (UTC -4 / UTC -5)* * The time zone is affected by whether daylight saving time or standard time is in effect.

OTT Play Sessions

This dataset contains play sessions which are rows of data containing attributes that pertain to a specific user watching a specific video in an implementation based on Apps.

Item	Description
Table name	`JW_DATA.PUBLIC.OTT_PLAY_SESSIONS_<jw_account_id>;`
Number of data attributes	See: Data Sharing metrics and dimensions
New play session row creation	A new row is created when either of the following occurs: The video player advances to the next video, such as in a playlist. The user leaves the page.
User session generation	Linking all play sessions for a specific user during a visit provides an understanding of the viewer's user session.
Data refresh rate	Continuously appended throughout the day

FAQs

How are play sessions created?

As a viewer watches a video, the player sends a ping at certain intervals or user actions. This data is combined together into a session to create a play session.

In instances when a viewer has an ad blocker enabled, some ping data may not be captured.

How is Time Watched calculated?

As a viewer watches a video, the player periodically sends a ping to JWP. JWP uses the duration between pings to calculate the Time Watched metric.