DIRECTV Ads Manager supports Snowflake Private Listings for customers who need large-scale, programmatic access to reporting data — typically for ingestion into internal BI tools or data pipelines. Using Snowflake Share allows DIRECTV Ads Manager to deliver live, continuously updated datasets directly to your Snowflake account without file transfers, APIs, or duplicated data.
What data is available
Through Snowflake Share, DIRECTV Ads Manager can provide log-level data and aggregated reporting data. Data is shared securely and in real time, allowing you to query DIRECTV Ads Manager data alongside your own internal datasets.
Why use Snowflake Share
Secure, real-time access to DIRECTV Ads Manager data
No data copying or manual integrations
Easy integration into existing BI tools and pipelines
Reduced maintenance compared to API-based ingestion
This option is best suited for technical teams with existing Snowflake and BI infrastructure.
Setup overview
To access DIRECTV Ads Manager data via Snowflake Share, you'll need to:
Create or use an existing Snowflake account
Set up a service user for your BI tool
Provide DIRECTV Ads Manager with your Snowflake Account Identifier
Accept the DIRECTV Ads Manager Private Listing
Grant your BI user access to the shared database
Step 1: Create or access a Snowflake account
Sign up for a Snowflake account and bookmark the Snowflake login page for future access.
Step 2: Create a key pair for secure access
Create a public/private key pair by following Snowflake's official guide. Keep the private key secure — it will be required for your BI tool to authenticate. DIRECTV Ads Manager does not need access to your private key.
Step 3: Create a dedicated BI user and role
Run SQL as a powerful admin (e.g., ACCOUNTADMIN) to create a service user and role for your BI tool. Create a BI_USER role, create a key-pair service user, and assign the role.
Step 4: Create a warehouse for the BI user
Create an XSMALL warehouse with auto-suspend and auto-resume enabled for the BI_USER service account.
Step 5: Grant warehouse privileges
Grant USAGE, OPERATE, and MONITOR privileges on the warehouse to the BI_USER role.
Step 6: Share your Snowflake Account Identifier
DIRECTV Ads Manager will need your Snowflake Account Identifier in order to share the Private Listing with your account.
Step 7: Accept the DIRECTV Ads Manager Private Listing
Log in to the Snowflake UI
Navigate to Data Products > Private Sharing > Privately Shared Listings
Locate the DIRECTV Ads Manager listing and click Get
Wait for the listing to prepare (you'll receive an email titled "Snowflake Marketplace: Request Fulfilled for Listing")
Click Get again and follow the prompts to create a database
Step 8: Grant BI user access to the shared database
Grant USAGE on the database and all schemas, and SELECT on all tables and views to the BI_USER role. Use FUTURE grants to ensure new objects are automatically accessible.
Accessing DIRECTV Ads Manager data
Once permissions are granted, connect your BI tool to Snowflake using the BI_USER service account and query the DIRECTV Ads Manager shared database directly. Data will remain live and up to date without additional ingestion steps.