Skip to content

Headset/vault-docs

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

21 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Headset

Vault

Your data. Your warehouse. No middleman.

Powered by Snowflake SQL Ready Secure Data Share


Vault delivers the same cannabis market data that powers Headset's analytics — directly into your Snowflake account via Secure Data Sharing. No ETL, no pipelines, no copies. The data stays in Snowflake and updates automatically.

Data Products

Vault is organized into three products, each tailored to a different use case:

Your stores, your data

Transaction-level sales, customer profiles, product catalog, and inventory for retailers who want full access to their own operational data.

6 views · Schema · Queries

Brand sell-through at retail

See how your products move through retail partners — sales, inventory, batches, and METRC package tracking for brands and distributors.

6 views · Schema · Queries

The whole market

Aggregated, anonymized market data — category trends, brand benchmarking, pricing intelligence, and package size analysis across all tracked markets.

4 views · Schema · Queries

Getting Started

1. Accept the share — Your Headset onboarding team will share a database to your Snowflake account. Accept it and give it whatever name you like. Don't have a Snowflake account? No problem — we can provision and manage one for you.

2. Connect — Use any Snowflake-compatible tool: SQL worksheets, Python, BI platforms, dbt, or anything else that speaks SQL. See Snowflake Basics for connection examples in Python, Node.js, C#, Go, and Rust.

3. Query — All data is in secure views, ready to SELECT immediately. Check the sample queries in each product section for a head start.

Works With Your Stack

Vault data lives in Snowflake, so it works with any tool that has a Snowflake connector — no extra setup required.

Tableau Looker Power BI dbt Python Sigma Hex Mode Metabase Excel

Quick Example

-- Top 10 products by revenue this month (Retailer)
SELECT
    PRODUCT_NAME,
    BRAND,
    CATEGORY,
    SUM(REVENUE) AS total_revenue,
    SUM(QUANTITY) AS total_units
FROM SALES
WHERE SOLD_DATE >= DATE_TRUNC('MONTH', CURRENT_DATE)
GROUP BY PRODUCT_NAME, BRAND, CATEGORY
ORDER BY total_revenue DESC
LIMIT 10;

Resources

Resource Description
Snowflake Basics Connection setup, authentication, and language-specific examples
Glossary Definitions of key terms used across Vault
Headset Support Help center for Headset products

Built with care by the Headset team

About

Headset Vault Documentation

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors