April 2017
Beginner to intermediate
360 pages
9h 35m
English
The status_update_views table gives us a complete and highly discrete view of the usage data we're collecting, but it is limited in terms of what questions it can answer. Of course, by analyzing the primary key structure, we know that the question it is best suited to answer is: What do we know about each view of a given status update in a given time range? We can answer this question using a range slice query of the following form:
SELECT "observed_at", "client_type" FROM "status_update_views" WHERE "status_update_username" = 'alice' AND "status_update_id" = 76e7a4d0-e796-11e3-90ce-5f98e903bf02 AND "observed_at" >= MINTIMEUUID('2014-10-05 00:00:00+0000') AND "observed_at" < MINTIMEUUID('2014-10-06 ...Read now
Unlock full access