Connect Stripe to Snowflake with Windsor.ai

stripe Field Reference logo

+

snowflake

Stream all your payment and subscription data from Stripe to Snowflake

About Stripe

Stripe is an online payment processing for internet businesses. Stripe offers a suite of payment APIs that powers commerce for online businesses of all sizes, including fraud prevention, and subscription management. With Stripes payment platform companies can accept and process payments online.

About Snowflake

Snowflake is a cloud data warehouse. Contrary to on premise data bases it eliminates the need to maintain hardware infrastructure. I’s architecture allow it to scale dynamically depending on the resource consumption needed by the users. The outcome of working with a cloud data warehouse like Snowflake is a greatly increased productivity of end users working with Snowflake data.

First Step:

Follow the Tutorial Below:

  1. Add all the columns that are returned by your connector’s URL. 
  2. Create the WINDOSR_UPLOAD role (name has no importance) 
  3. Create a user and add the previously created role to that user 
  4. Grant rights to the DATABASE to the created user 
  5. Grand the rights to the destination table 
  6. Get the rerquired fields from Snowflake to use the Snowflake destination in Onboard Form
  1. Get the username 
  2. Get the password 
  3. Get the account 
  4. Get the warehouse 
  5. Get the database 
  6. Get the schema 
  7. Get the table name 

Second step:

1.You need to select Stripe as a Data Source and Grant Access to Windsor.ai.

  1. In Select Destination select Snowflake as destination
  2. Enter all the credentials required and click Save
  3. Your data will now be streamed to Snowflake. In case there is an error you will be notified.

You should also read:

Stream Your Data to Snowflake

How to connect Stripe to Windsor.ai

Looker Studio Stripe Overview Report

Stripe metrics and dimensions available for streaming into Snowflake

NameTypeDescription
WWW

Windsor.ai: Easily connect Stripe to Snowflake

See the value and return on every marketing touchpoint

data warehouse

Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketeers, whenever they want.

insights

Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.

Start a free trial today.

Integrate all your data and measure what matters.