Skip to main content
This example delivers the Stripe account stream into analytics.stripe_account. The same workflow applies to the other supported streams.

​
1. Create the connections

  1. Create a Stripe Source connection with a secret or restricted read key.
  2. Test and save the connection.
  3. Create a PostgreSQL Destination connection.
  4. Test and save the destination.

​
2. Discover the Stripe catalog

  1. Create a pipeline with the Stripe source.
  2. Open Source and click Discover catalog.
  3. Enable account.
  4. Preview the stream, review its typed fields, and click Save stream settings.
For broader coverage, select additional streams after preparing one model and destination table for each delivered output. Valid empty streams are successful and do not require fabricated sample records.

​
3. Prepare the destination

Open Destinations, add the PostgreSQL connection, and save it. After the SQL revision is published, open this destination’s Published output targets, enter analytics.stripe_account, use the stable account identifier as its Upsert key, and use the explicit table setup action when needed. The final table must exist before the run starts.

​
4. Add and publish a stable model

Open Transformations, select the PostgreSQL destination, create a transformation using stripe.account as input, and use:
Prefer explicit columns over SELECT *; Stripe responses can include optional fields that are not part of your destination contract.

​
5. Validate and run

  1. Set the final table to analytics.stripe_account.
  2. Set the Upsert key.
  3. Save draft, Validate draft, and Preview output.
  4. Publish revision.
  5. Validate the pipeline from Overview.
  6. Click Run all.
  7. Confirm success, rows written, revision, and target in Runs.

​
6. Expand to more streams

Repeat the destination/model setup for every additional stream you intend to deliver. Streams with a created cursor can use Incremental sync after a successful first run. Cursorless streams remain Full Table. See Stripe source for the complete 34-stream inventory and current limitations.