Skip to main content
ClickHouseCustomer feedback

Engineers discussing a guide to ingesting Stripe Data Pipeline exports into ClickHouse criticize the high friction of ClickPipes requiring separate pipelines and materialized views across 40 tables.

Source: Autobound Signal API · 83 signals tracked for ClickHouse · updated

Get ClickHouse's live signals in Claude or ChatGPT, or by API

AskWhat changed at ClickHouse this week? Use Autobound signals for clickhouse.com.

What happened

Post: "Set up Stripe Data Pipeline for ClickHouse"

Source

RedditOct 31, 2026By u/tanin47

r/stripe

Set up Stripe Data Pipeline for ClickHouse

upvotes
1
comments
19

Extracted from these lines

  • [comment u/Inner_Discount_7504] That's a brutal amount of clicking for something that should be one config.

  • [comment u/Turbulent_Tank726] One ClickPipe per table" isn't a gotcha, that's just how ClickPipe works. If clicking through the UI once per table annoys you, script it.

  • [comment u/First_Requirement243] 40 clickpipes and 40 materialized views just to get stripe data into clickhouse. at that point just write the cron job yourself

reddit.com/r/stripe/comments/1xkjagx/set_up_stripe_data_pipeline_for_...Open the source

Comments on the post

5 of 19 comments
  • “40+ materialized views just to dedupe is using the wrong tool. ReplacingMergeTree with a version column handles the daily re-exports on its own, you don't need a view per table for that.”

    u/OkZookeepergame34492 points · Oct 31, 2026View

  • “One ClickPipe per table" isn't a gotcha, that's just how ClickPipe works. If clicking through the UI once per table annoys you, script it. The duplicated records from the daily full export is the part I'd actually complain about, and a materialized view only hides that you're paying to re-ingest the same rows every day.”

    u/Turbulent_Tank7262 points · Oct 31, 2026View

  • “40 ClickPipes is fine if you script the setup once, it's not the weekly pain. The materialized view per table is the part that would annoy me, at that point just put a ReplacingMergeTree on top of the S3 export and let the engine do the dedupe.”

    u/Capital_Unit_78792 points · Oct 31, 2026View

  • “"Their docs are a bit scattered" is a generous way to describe finding out it's 40 ClickPipes and 40 materialized views done by hand.”

    u/AccessFormal36602 points · Oct 31, 2026View

  • “That's a lot of clicking for what should be one job. Instead of 40 ClickPipes, point a single pipe at the bucket root with a glob (`**.json.gz`) and use the `_path`virtual column to tell the tables apart, then one materialized view with `ReplacingMergeTree`on the record id handles the daily dupes for all of them. Stripe writes the table name into the path so you already have what you need to split”

    u/Independent-Fig-49762 points · Nov 1, 2026View

Extracted by Autobound

From the Signal API record
Signal
Customer feedback

What this signalsUser posts often show product pain before it reaches reviews or churn.

Subreddit
r/stripe
Event date
Oct 2026

Companies

  • StripeAlso named

The full record

From the Signal API record

Numbers

Mentions
3

Details

Timing
Ongoing state
Category
Usability
Virality
Medium
Post kind
Link
Prominence
Core
Company's role
Vendor

Topics and mentions

Topics

  • clickhouse
  • data pipeline
  • clickpipes
  • data integration
  • usability

Products named

  • ClickPipe

Extraction

Sentiment
Negative
Detected
Oct 31, 2026
signal_type
reddit-company
signal_subtype
customerFeedback

Use this data

Get every Reddit signal for ClickHouse and the companies you sell to, in the tools you already use.

  1. Ask Claude about it

    Connect Autobound to Claude, Claude Code or Cursor with MCP. Then ask: “What changed at ClickHouse this week?”

  2. Send it to your own tools

    The Signal API returns Reddit signals for any list of companies as JSON, for your CRM, warehouse or app.

  3. Try it free

    Sign up and spend your free credits on the companies you sell to.

    Start Free1,000 free credits

The API returns more than this page shows

This page shows a preview. The full reddit-company record in the Signal API and MCP can also have these 8 fields. Some fields are empty for some signals.

Company

  • linkedin_urlValue in the API
  • industriesValue in the API
  • employee_count_lowValue in the API
  • employee_count_highValue in the API
  • revenueValue in the API
  • descriptionValue in the API

Signal

  • signal_nameValue in the API
  • associationValue in the API
Show the full JSONThe record on this page and the API request

GET /v1/signals/d62614f6-fd13-5d6d-a56a-f85a0ea4d36b returns this record as JSON. POST /v1/companies/enrich returns every signal for clickhouse.com.

{
  "signal_id": "d62614f6-fd13-5d6d-a56a-f85a0ea4d36b",
  "signal_type": "reddit-company",
  "signal_subtype": "customerFeedback",
  "detected_at": "2026-10-31T19:36:57+00:00",
  "company": {
    "name": "ClickHouse",
    "domain": "clickhouse.com"
  },
  "data": {
    "nsfw": false,
    "stage": "none",
    "awards": 0,
    "timing": "ongoing_state",
    "topics": [
      "clickhouse",
      "data pipeline",
      "clickpipes",
      "data integration",
      "usability"
    ],
    "post_id": "1xkjagx",
    "summary": "Engineers discussing a guide to ingesting Stripe Data Pipeline exports into ClickHouse criticize the high friction of ClickPipes requiring separate pipelines and materialized views across 40 tables.",
    "category": "usability",
    "comments": [
      {
        "url": "https://www.reddit.com/r/stripe/comments/1xkjagx/comment/19ry1btcfy92b/",
        "depth": 0,
        "score": 2,
        "author": "OkZookeepergame3449",
        "excerpt": "40+ materialized views just to dedupe is using the wrong tool. ReplacingMergeTree with a version column handles the daily re-exports on its own, you don't need a view per table for that.",
        "posted_at": "2026-10-31T20:00:22.000Z",
        "author_url": "https://www.reddit.com/user/OkZookeepergame3449/"
      },
      {
        "url": "https://www.reddit.com/r/stripe/comments/1xkjagx/comment/19ry3i9wl1tnn/",
        "depth": 0,
        "score": 2,
        "author": "Turbulent_Tank726",
        "excerpt": "One ClickPipe per table\" isn't a gotcha, that's just how ClickPipe works. If clicking through the UI once per table annoys you, script it. The duplicated records from the daily full export is the part I'd actually complain about, and a materialized view only hides that you're paying to re-ingest the same rows every day.",
        "posted_at": "2026-10-31T20:49:14.000Z",
        "author_url": "https://www.reddit.com/user/Turbulent_Tank726/"
      },
      {
        "url": "https://www.reddit.com/r/stripe/comments/1xkjagx/comment/19ry9ghkngh29/",
        "depth": 0,
        "score": 2,
        "author": "Capital_Unit_7879",
        "excerpt": "40 ClickPipes is fine if you script the setup once, it's not the weekly pain. The materialized view per table is the part that would annoy me, at that point just put a ReplacingMergeTree on top of the S3 export and let the engine do the dedupe.",
        "posted_at": "2026-10-31T23:02:38.000Z",
        "author_url": "https://www.reddit.com/user/Capital_Unit_7879/"
      },
      {
        "url": "https://www.reddit.com/r/stripe/comments/1xkjagx/comment/19rybvpk0z1b6/",
        "depth": 0,
        "score": 2,
        "author": "AccessFormal3660",
        "excerpt": "\"Their docs are a bit scattered\" is a generous way to describe finding out it's 40 ClickPipes and 40 materialized views done by hand.",
        "posted_at": "2026-10-31T23:56:57.000Z",
        "author_url": "https://www.reddit.com/user/AccessFormal3660/"
      },
      {
        "url": "https://www.reddit.com/r/stripe/comments/1xkjagx/comment/19rycws440c4k/",
        "depth": 0,
        "score": 2,
        "author": "Independent-Fig-4976",
        "excerpt": "That's a lot of clicking for what should be one job. Instead of 40 ClickPipes, point a single pipe at the bucket root with a glob (`**.json.gz`) and use the `_path`virtual column to tell the tables apart, then one materialized view with `ReplacingMergeTree`on the record id handles the daily dupes for all of them. Stripe writes the table name into the path so you already have what you need to split",
        "posted_at": "2026-11-01T00:20:03.000Z",
        "author_url": "https://www.reddit.com/user/Independent-Fig-4976/"
      },
      {
        "url": "https://www.reddit.com/r/stripe/comments/1xkjagx/comment/19ryeda5kwvvp/",
        "depth": 0,
        "score": 2,
        "author": "OkStatistician9961",
        "excerpt": "wait why does the book name make it sound like some medieval ledger but it's actually a revenue blog",
        "posted_at": "2026-11-01T00:52:44.000Z",
        "author_url": "https://www.reddit.com/user/OkStatistician9961/"
      },
      {
        "url": "https://www.reddit.com/r/stripe/comments/1xkjagx/comment/19ry3ym0axkrl/",
        "depth": 0,
        "score": 2,
        "author": "CalligrapherInner715",
        "excerpt": "It's called Book of Revenue and it's a blog. I got stuck on that longer than I should have.",
        "posted_at": "2026-10-31T20:59:24.000Z",
        "author_url": "https://www.reddit.com/user/CalligrapherInner715/"
      },
      {
        "url": "https://www.reddit.com/r/stripe/comments/1xkjagx/comment/19ryjhpi99x7k/",
        "depth": 0,
        "score": 1,
        "author": "Similar_Anteater2568",
        "excerpt": "40 ClickPipes, no thanks.",
        "posted_at": "2026-11-01T02:47:36.000Z",
        "author_url": "https://www.reddit.com/user/Similar_Anteater2568/"
      }
    ],
    "evidence": [
      "[comment u/Inner_Discount_7504] That's a brutal amount of clicking for something that should be one config.",
      "[comment u/Turbulent_Tank726] One ClickPipe per table\" isn't a gotcha, that's just how ClickPipe works. If clicking through the UI once per table annoys you, script it.",
      "[comment u/First_Requirement243] 40 clickpipes and 40 materialized views just to get stripe data into clickhouse. at that point just write the cron job yourself"
    ],
    "link_url": "https://bookofrevenue.com/blog/6ae4d508e115910001bc9bb2/set-up-stripe-data-pipeline-for-clickhouse",
    "virality": "medium",
    "post_date": "2026-10-31T19:36:57.000Z",
    "post_kind": "link",
    "sentiment": "negative",
    "subreddit": "stripe",
    "event_date": "2026-10",
    "post_title": "Set up Stripe Data Pipeline for ClickHouse",
    "prominence": "core",
    "source_url": "https://www.reddit.com/r/stripe/comments/1xkjagx/set_up_stripe_data_pipeline_for_clickhouse/",
    "entity_role": "vendor",
    "post_author": "tanin47",
    "upvote_ratio": 1,
    "mention_count": 3,
    "mention_surge": true,
    "subreddit_url": "https://www.reddit.com/r/stripe/",
    "total_upvotes": 1,
    "comments_total": 19,
    "total_comments": 19,
    "other_companies": [
      {
        "name": "Stripe",
        "role": "partner",
        "domain": "stripe.com"
      }
    ],
    "post_author_url": "https://www.reddit.com/user/tanin47/",
    "signal_category": "feedback",
    "comments_included": 13,
    "products_mentioned": [
      "ClickPipe"
    ]
  }
}

Long text fields are shortened on this page.

Looking up one signal by its id is free. Enrich costs 2 credits per signal returned; a call with no results is free.