Overview

This section describes the available API objects and how to interact with them using SQL.

The Dahlia schema is the default schema in the add-in, and targets the 2026-04-22.dahlia Stripe API version. Unlike the Stripe schema (which targets only the v1 namespace) and the StripeV2 schema (which targets only the v2 namespace), this schema unifies the entities in both the schemas and it supports entities that can be either of v1 or v2 endpoints.

Key Features

• The add-in models Stripe entities from both the v1 namespace (like Accounts, Invoices, Customers, Meters, and Subscriptions), and the v2 namespace (like ThinEvents and EventDestinations) as relational Tables and Views allowing you to write SQL to query and modify Stripe data.
• Stored Procedures allow you to perform tasks beyond standard CRUD operations, such as managing subscriptions, processing payments, handling climate orders, and configuring billing meters in Stripe.
• Live connectivity to these objects means any changes to your Stripe account are immediately reflected when using the add-in.