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 to 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.
Prerequisites
Item | Description |
---|---|
Data Sharing Entitlement | Entitlement to access and query granular JWP performance data For more information, contact your JWP representative. |
Snowflake Account ID | (Direct Snowflake Share) Unique identifier for your Snowflake account |
Set up Data Sharing
JWP offers two options for setting up Data Sharing. Each option is explained in the following sections.
Direct Snowflake Share
Follow these steps if you already have a Snowflake account:
- On the Data Sharing page, Input your Snowflake Account ID.
Your Snowflake account must be in AWS US West-2. You can also set up a new sub-region in your Snowflake account.
- Click Confirm. A confirmation will appear when the setup has completed.
- In your Snowflake account, accept the connection.
Basic Direct Share Connection Details
Role | Public |
Database | JW_DATA |
Schema | Public |
Snowflake Reader Account
Follow these steps if you do not have a Snowflake account:
-
On the Data Sharing page, click Create a Snowflake account. A confirmation will appear when the setup has completed.
-
Click Set password to set a password.
You can use the Set password link to reset the password.
- Click Snowflake login instance to log in to the Snowflake instance using the specified username and password.
You can use the following information to set up Snowflake access with a database tool.
Hostname / Account URL https://jwplayer-reader_<jw_account_id>.snowflakecomputing.com/
Warehouse MEDIUM
Role Public
Database JW_DATA
Schema Public
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 |
To view datasets that are only available in Data Sharing, see Data Sharing datasets.
Updated 8 months ago