Developers note that Stripe Data Pipeline's full daily re-exports create duplicated records that require deduplication strategies like ReplacingMergeTree or paid re-ingestion downstream.

{
  "signal_id": "35e18500-83b9-5ff2-ad84-0dbe1aca991c",
  "signal_type": "reddit-company",
  "signal_subtype": "customerFeedback",
  "detected_at": "2026-10-31T19:36:57+00:00",
  "company": {
    "name": "Stripe",
    "domain": "stripe.com"
  },
  "data": {
    "nsfw": false,
    "stage": "none",
    "awards": 0,
    "timing": "ongoing_state",
    "topics": [
      "data pipeline",
      "deduplication",
      "data export"
    ],
    "post_id": "1xkjagx",
    "summary": "Developers note that Stripe Data Pipeline's full daily re-exports create duplicated records that require deduplication strategies like ReplacingMergeTree or paid re-ingestion downstream.",
    "category": "features",
    "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/Turbulent_Tank726] 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.",
      "[comment u/OkZookeepergame3449] 40+ materialized views just to dedupe is using the wrong tool. ReplacingMergeTree with a version column handles the daily re-exports on its own"
    ],
    "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": 31,
    "mention_surge": true,
    "subreddit_url": "https://www.reddit.com/r/stripe/",
    "total_upvotes": 1,
    "comments_total": 19,
    "total_comments": 19,
    "other_companies": [
      {
        "name": "ClickHouse",
        "role": "partner",
        "domain": "clickhouse.com"
      }
    ],
    "post_author_url": "https://www.reddit.com/user/tanin47/",
    "signal_category": "feedback",
    "comments_included": 13,
    "products_mentioned": [
      "Stripe Data Pipeline"
    ]
  }
}

curl https://signals.autobound.ai/v1/signals/35e18500-83b9-5ff2-ad84-0dbe1aca991c \
  -H "X-API-KEY: $AUTOBOUND_API_KEY"

curl -X POST https://signals.autobound.ai/v1/companies/enrich \
  -H "X-API-KEY: $AUTOBOUND_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"domain":"stripe.com","limit":20}'