SELECT
   RESOURCE_ATTRIBUTES:"snow.application.name"::STRING as APP_NAME
   ,RECORD
   ,RECORD_ATTRIBUTES
   ,RECORD_TYPE
   ,TIMESTAMP
FROM <YOUR_EVENT_TABLE>
WHERE RECORD_TYPE LIKE 'SPAN_EVENT%'
   AND APP_NAME = '<YOUR_APP_NAME>'
ORDER BY TIMESTAMP DESC
limit 100;