Stripe Connector

<br/>23 metrics. 142 dimensions. Zero pipelines. Windsor.ai streams your Stripe payment data into Snowflake—fully typed and analysis-ready.<br/><br/>**1. Scope & Value**

- **Up-to-date payment data**Stream charges, customers, subscriptions, and payout data directly from Stripe into your Snowflake instance.
- **Query-ready on arrival**Data lands in fully typed tables (no VARIANT columns) and loads incrementally, run financial and revenue analyses within seconds using SQL.
- **Runs 100% in your Snowflake account**Executes as a Snowflake Native App, inheriting Snowflake’s security, governance, and role-based access controls.
- **Zero maintenance required**Windsor.ai automatically handles schema evolution, backfills, retries, and rate limits, freeing you to focus on insights, not infrastructure.

**2. Sample Tables & Schemas**

- **STRIPE_CHARGES** grain: charge – Sample fields include: charge_id, customer_id, amount, currency, status, created, description, receipt_url, _load_timestamp
- **STRIPE_CUSTOMERS** grain: customer – Sample fields include: customer_id, email, name, description, created, currency, delinquent
- **STRIPE_SUBSCRIPTIONS** grain: subscription – Sample fields include: subscription_id, customer_id, plan_id, status, start_date, end_date, current_period_start, current_period_end, _load_timestamp

**3. Workflow for Data Consumers**

1. Install the Stripe Connector
2. Authenticate your Stripe account
3. Select your account and choose the destination database/schema (tables are created automatically)
4. Start querying and sharing: join with other business data, power dashboards, or share securely via Snowflake Secure Share

原始信息汇总

Stripe Connector 数据集概述

数据集提供商

• Windsor.ai

数据集访问

• 免费
• 无限访问

数据集内容

• 包含23个指标和142个维度
• 数据类型：完全类型化表格（无VARIANT列）
• 数据加载方式：增量加载

数据表结构

STRIPE_CHARGES

• 粒度：charge
• 示例字段：charge_id, customer_id, amount, currency, status, created, description, receipt_url, _load_timestamp

STRIPE_CUSTOMERS

• 粒度：customer
• 示例字段：customer_id, email, name, description, created, currency, delinquent

STRIPE_SUBSCRIPTIONS

• 粒度：subscription
• 示例字段：subscription_id, customer_id, plan_id, status, start_date, end_date, current_period_start, current_period_end, _load_timestamp

业务流程

1. 安装Stripe Connector
2. 验证Stripe账户
3. 选择账户和目标数据库/模式（自动创建表格）
4. 开始查询和共享

业务需求

财务报告与对账

• 提供清晰的收入、费用和支付视图
• 加快月末结算过程

订阅分析

• 分析关键指标：月度经常性收入（MRR）、客户流失率和生命周期价值（LTV）

安全性

• 通过Snowflake安全审查
• 基于角色的访问控制
• 推荐授予的权限：账户级别权限、对象权限、连接权限、应用事件权限

数据刷新

• 静态数据

云区域可用性

AWS

• Africa (Cape Town)
• Asia Pacific (Jakarta)
• Asia Pacific (Mumbai)
• Asia Pacific (Osaka)
• 45 More

法律条款

• 标准条款

关于提供商

• Windsor.ai帮助连接325+营销、分析、销售和CRM平台，并将数据流式传输到Snowflake