<br />

Data Sharing gives you access to video consumption insights that can help you better understand the performance of your videos. Leveraging Snowflake's <a href="https://docs.snowflake.com/en/user-guide/data-sharing-intro" target="_blank">Secure Data Sharing</a>, 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:

<br />

  • **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 <a href="https://docs.snowflake.com/en/user-guide/ecosystem" target="_blank">Snowflake Ecosystem</a>, such as leading business intelligence tools.

  • **Deeper Insights**: Access individual play sessions, additional metrics and dimensions, and control time ranges.

<br />




## Set up Data Sharing

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

<br />

### Direct Snowflake Share

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

  1. Provide your <a href="https://docs.snowflake.com/en/user-guide/admin-account-identifier" target="_blank">Snowflake Account ID</a> to your JWP representative. Your JWP representative will notify you when the data share is configured.

  2. <a href="https://docs.snowflake.com/en/user-guide/data-share-consumers" target="_blank">Accept the connection</a>.

<br />

#### Basic Direct Share Connection Details

<span class="manual-tbl-font"> <table> <tbody> <tr> <td width="25%"> <strong>Role</strong> </td> <td width="75%"> <code>Public</code> </td> </tr> <tr> <td> <strong>Database</strong> </td> <td> <code>JW_DATA</code></td> </tr> <tr> <td> <strong>Schema</strong> </td> <td> <code>Public</code> </tr> </tbody> </table> </span>

<br /><br />

### Snowflake Reader Account

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

  1. 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.

<br />

#### Basic Reader Account Connection Details

<span class="manual-tbl-font"> <table> <tbody> <tr> <td width="25%"> <strong>Hostname / Account URL </strong> </td> <td width="75%"> <code>https://jwplayer-reader_&lt;jw_account_id&gt;.snowflakecomputing.com/</code> </td> </tr> <tr> <td> <strong>Warehouse</strong> </td> <td> <code>MEDIUM</code></td> </tr> <tr> <td> <strong>Role</strong> </td> <td> <code>Public</code> </td> </tr> <tr> <td> <strong>Database</strong> </td> <td> <code>JW_DATA</code></td> </tr> <tr> <td> <strong>Schema</strong> </td> <td> <code>Public</code> </tr> </tbody> </table> </span>

<br />




## Reference

### Data Access

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

<span class="manual-tbl-font"> <table> <thead> <tr> <th> Approach </th> <th> Notes </th> </tr> </thead> <tbody> <tr> <td width="25%"> <strong>Direct Connection</strong> </td> <td width="75%"> Enables directly connecting to any data tools that allow a standard Snowflake connection from the <a href="https://docs.snowflake.com/en/user-guide/ecosystem" target="_blank">Snowflake Ecosystem</a>, such as leading business intelligence tools </td> </tr> <tr> <td> <strong>Data Replication</strong> </td> <td> Enables replicating data into a data warehouse, such as Redshift and BigQuery <br /><br /> This can be a customer-built integration that queries the data at regular intervals or uses any <a href="https://docs.snowflake.com/en/user-guide/ecosystem" target="_blank">data replication tool supporting a Snowflake connection</a>. </td> </tr> <tr> <td> <strong>Data Export</strong> </td> <td> Enables <a href="https://docs.snowflake.com/en/guides-overview-unloading-data" target="_blank">bulk unloading of data</a> from a database table into flat, delimited text files</td> </tr> </tbody> </table> </span>

<br /><br />



To view datasets that are only available in Data Sharing, see <a href="https://docs.jwplayer.com/platform/docs/data-sharing-datasets" target="_blank">Data Sharing datasets</a>.

<br />




## FAQs

<details><summary><strong>How are play sessions created?</strong></summary>

<br />

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.

<br />

</details>

<details><summary><strong>How is Time Watched calculated?</strong></summary>

<br />

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.

<br />

</details>

<br />

<!-- Removes the automatic page-to-page navigation at the bottom of the page -->

<style> .rm-Pagination { display: none; } </style>