USE WAREHOUSE COMPUTE_WH;
USE DATABASE "CUSTOMERS";

// Get CUrrent List of meta-data
select distinct CUSTOMER:metadata
from SNOWSTORE.PUBLIC.FACETRACKING
;


//Get last 100 frames of the image
select
CUSTOMER:imgName::STRING as IMG
, CUSTOMER:time AS TIME
from SNOWSTORE.PUBLIC.FACETRACKING,
table(flatten(input => CUSTOMER:facesdetected.FaceDetails ) )
order by 2 desc
limit 100
;