Treating Pricing Changes Like Code Deploys

Summary

Thumbtack manages marketplace pricing by updating hundreds of thousands of bid settings stored in DynamoDB across service offerings. Previously executed through individual custom Go scripts, these pricing rollouts lacked automated runtime state tracking, dynamic database throughput pacing, and durable records for reliable rollbacks. To eliminate manual operational risk, engineering introduced a shared deployment-like engine that accepts declarative target states and executes pure Go transformation functions without direct I/O. The engine enforces idempotency, conducts dry runs with validation reports to S3, coordinates atomic DynamoDB updates with audit logging, and dynamically manages write capacity. This platform standardizes pricing updates into reviewable, resumable, and reversible operations that safely skip already written rows and check for production drift during rollbacks.

Takeaways

1. 1

   Declarative target-state inputs make bulk data updates idempotent, allowing failed or interrupted runs to safely resume without re-applying relative changes.

2. 2

   The engine temporarily increases DynamoDB write capacity at startup, registers a deferred reset handler for safe cleanup on exit or panic, and paces writes using computed sleep intervals.

3. 3

   Rollback safety checks must account for internal data normalization to prevent drift detection from falsely rejecting unmodified records.