Snowflake

AMP DATA PIPELINE

AMP Data Pipeline sends sales and wash activity data from the AMP platform to the Snowflake Data Cloud allowing you to consolidate AMP data with point-of-sale activity to automate financial and operational reporting.

Automate Data Delivery

Start syncing AMP data to your Snowflake organization within minutes. No coding required!

Unified View of Your Data

Snowflake allows you to create a single-source-of-the-trooth for all your data sources. Unlock the power of having financial and operational data at your fingertips for better insights and decision support analytics.

Streamlined Security

Eliminate the need for transferring files and reports via traditional means (e.g. email, FTP, custom development) by leveraging the industry leading security architecture of Snowflake.

Expected Workflow

Provide the account information associated with your Snowflake data warehouse
Accept the data share request, typically with 48 hours
Start querying your AMP data in your own data warehouse

Usage Examples

What memberships have been sold in AMP last month?

This query returns the memberships that were sold in AMP over the past 30 days.

				
					SELECT 
    product, 
    customer_id, 
    customer_email,
    purchase_location,
    payment_date,
    line_item_total_amount as amount
FROM 
    GENERAL.AMP_SALES
WHERE 
    payment_date >= dateadd('day', -30, current_date())
AND
    product_type = 'Unlimited Plan';

How many memberships and washes were purchased at each location last month?

This query returns the number of memberships an individual washes sold in AMP over the past 30 days.

				
					SELECT 
    purchase_location,
    product_type,
    COUNT(invoice_line_item_id) as sales
FROM 
    GENERAL.AMP_SALES
WHERE 
    payment_date >= dateadd('day', -30, current_date())
AND
    product_type = 'Unlimited Plan'
GROUP BY
    purchase_location,
    product_type;