QuickBooks Connector

Stream 59 metrics and 480 dimensions from QuickBooks into Snowflake with the QuickBooks Connector powered by Windsor.ai — no pipelines, no delays, just clean, query-ready data.<br/><br/>**1. Scope & Value**

- **Always up-to-date accounting data** Ingest invoices, bills, payments, and customer data directly into your Snowflake environment.
- **Query-ready on arrival** Data lands in fully typed tables (no VARIANT columns), incrementally loaded for immediate SQL analysis.
- **Runs 100% in your account** Executes entirely within your Snowflake warehouse, leveraging native security, governance, and RBAC.
- **Zero maintenance** Windsor.ai handles schema changes, backfills, retries, and rate limits automatically.

**2. Sample Tables & Schemas**

- **QB_INVOICES** - grain: invoice. Sample fields include invoice_id, customer_id, invoice_date, due_date, total_amount, balance, currency, status, _load_timestamp
- **QB_CUSTOMERS** - grain: customer. Sample fields include customer_id, company_name, contact_name, email, phone, address, city, state, postal_code,

**3. Workflow for Data Consumers**

1. Install the QuickBooks Connector from Snowflake Marketplace.
2. Authenticate with your QuickBooks account.
3. Select the desired company file.
4. Choose your target database and schema (tables are created automatically).
5. Start querying: join with other datasets, power dashboards, or securely share via Snowflake Secure Share

原始信息汇总

QuickBooks Connector 数据集概述

数据集基本信息

• 数据集名称: QuickBooks Connector
• 提供商: Windsor.ai
• 访问权限: 免费
• 数据更新频率: 静态数据

数据集描述

将QuickBooks数据连接到Snowflake，通过Windsor.ai驱动的QuickBooks连接器将59个指标和480个维度从QuickBooks流式传输到Snowflake。

主要特性

• 始终更新的会计数据
• 查询就绪的数据到达
• 100%在用户账户中运行
• 零维护

数据表结构

QB_INVOICES表

• 粒度: 发票
• 示例字段: invoice_id, customer_id, invoice_date, due_date, total_amount, balance, currency, status, _load_timestamp

QB_CUSTOMERS表

• 粒度: 客户
• 示例字段: customer_id, company_name, contact_name, email, phone, address, city, state, postal_code

使用流程

1. 从Snowflake Marketplace安装QuickBooks连接器
2. 使用QuickBooks账户进行身份验证
3. 选择所需的公司文件
4. 选择目标数据库和模式（表自动创建）
5. 开始查询：与其他数据集连接、为仪表板提供支持或通过Snowflake Secure Share安全共享

业务需求应用

• 财务报告和分析
• 业务绩效管理

安全特性

• 原生应用框架安全设计
• 已完成Snowflake安全审查
• 基于角色的访问控制

云区域可用性

• AWS: 非洲（开普敦）、亚太（雅加达）、亚太（孟买）、亚太（大阪）等46个区域

提供商信息

• 销售联系: [e-mail]
• 支持链接: https://support.windsor.ai/