Nitin: Card/token add/delete dates
Mon Nov 07 2022 10:35:46 GMT+0000 (Coordinated Universal Time)
Saved by
@shubhangi_burle
SELECT DISTINCT eventdata_globalcardid, eventdata_tokenid,
IF(eventtype = 'CARD_UNSTAGED', 'CARD_ADDED_PRE_TOKENIZATION', eventtype) AS event,
eventdata_merchanttransactionid, year, month, day FROM foxtrot_stream.vault_default
WHERE year = 2022 AND eventtype IN ('USER_CARD_DELETED', 'CARD_UNSTAGED', 'TOKEN_REGISTERED', 'TOKEN_DELETE')
AND ((eventdata_userid = 'U1612041824331881735953') OR (eventdata_merchantuserid = 'U1612041824331881735953'))
ORDER BY year, month, day
content_copyCOPY
Comments