Skip to content

Instantly share code, notes, and snippets.

@anand086

anand086/athena_transaction_details.sql

Created February 17, 2022 18:25
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anand086/fb765ffe54c6620d792edd0b9ff84ebc to your computer and use it in GitHub Desktop.
Save anand086/fb765ffe54c6620d792edd0b9ff84ebc to your computer and use it in GitHub Desktop.
Download ZIP
Raw
athena_transaction_details.sql
SELECT additionaldata.cardholdername,
card_detail.cardtype,
transaction.currency[1] as currency,
transaction.amount,
from_unixtime(transaction.created_at/1000.0) as timestamp
FROM msk_transaction_events WHERE success=true and transaction.amount > 7000 order by 5 desc
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment