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:
|
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:
|
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.
Updated 18 days ago