QuestionQ68

VerifiedStoring the data

You work for a large ecommerce company and store customer order data in Bigtable. A garbage collection policy deletes data after 30 days, and the number of versions is set to 1. When data analysts run a query to report total customer spending, they sometimes see customer data older than 30 days. You need to ensure the analysts do not see customer data older than 30 days while minimizing cost and overhead. What should you do?

Explanation

Bigtable garbage collection is asynchronous, so expired cells can remain visible in reads until a later compaction removes them. A timestamp range filter restricts query results to cells within the required recent time window, immediately excluding data older than 30 days without introducing a separate deletion process. Google Cloud recommends applying read filters that exclude the same values as the garbage-collection rules.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!