Usage Examples

How to subscribe to and utilize the Purchase Transactions dataset

Retrieve everything

select * from tiki.transactions

Retrieve based on time span

select *
from tiki.transactions
where transaction_date > current_timestamp - interval '5' year

Retrieve transactions for specific merchants

select *
from tiki.transactions
where
  merchant_name in ('Taco Bell', 'Starbucks')
  or clean_merchant_name in ('Taco Bell', 'Starbucks')

Left join with demographic data (will still get transactions for users without matching demographic data)

select *
from tiki.transactions t
left join tiki.demographics d on t.transactions = d.demographics