Skip to content

Instantly share code, notes, and snippets.

with
dau as (
-- This part of the query can be pretty much anything.
-- The only requirement is that it have three columns:
-- dt, user_id, inc_amt
-- Where dt is a date and user_id is some unique identifier for a user.
-- Each dt-user_id pair should be unique in this table.
-- inc_amt represents the amount of value that this user created on dt.
-- The most common case is
-- inc_amt = incremental revenue from the user on dt
Verifying my Blockstack ID is secured with the address 194nvEnYffbcN891GNHBC5RMibqHThkVnR https://explorer.blockstack.org/address/194nvEnYffbcN891GNHBC5RMibqHThkVnR
Verifying my Blockstack ID is secured with the address 1mbbDvHzfnMgdYrMutsT2qxvZL87fXGGX https://explorer.blockstack.org/address/1mbbDvHzfnMgdYrMutsT2qxvZL87fXGGX

Keybase proof

I hereby claim:

  • I am paxanthos on github.
  • I am paximus (https://keybase.io/paximus) on keybase.
  • I have a public key ASBh67X37JvwBdE70VXhYzT6NQs2zixbTg0CJCW-TNUPiwo

To claim this, I am signing this object: