SHARE
TWEET

Untitled

a guest Sep 17th, 2019 93 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. USE WAREHOUSE COMPUTE_WH;
  2. USE DATABASE "CUSTOMERS";
  3.  
  4. // Get CUrrent List of meta-data
  5. select distinct CUSTOMER:metadata
  6. from SNOWSTORE.PUBLIC.FACETRACKING
  7. ;
  8.  
  9.  
  10. //Get last 100 frames of the image
  11. select
  12. CUSTOMER:imgName::STRING as IMG
  13. , CUSTOMER:time AS TIME
  14. from SNOWSTORE.PUBLIC.FACETRACKING,
  15. table(flatten(input => CUSTOMER:facesdetected.FaceDetails ) )
  16. order by 2 desc
  17. limit 100
  18. ;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top