Review prompt never fired for 57 days due to a camelCase column mismatch
A review-request gate for CogniPrep customers silently read zero for every purchaser between 16 September and 12 November. The cause was a Postgres client transform that converts column names to camelCase, while raw SQL queries were still reading snake_case keys. Only the three since-purchase counts and the first-purchase timestamp were affected, while single-word aliases came through correctly. Because a zero looks like a legitimate new customer, the failure raised no error or alert. The team fixed it by quoting camelCase aliases explicitly in its raw queries, which works regardless of the transform configuration.
This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)
Log in to join the discussion and vote.
Log in