To be able to get an overview of historical jobs and the latest status of your Data Shares to Snowflake you can create an
export_summary table from your Snowflake Data Share in Funnel. All Data Shares in the same Funnel Workspace will append rows to the same table. The export summary table is always written after all data has been shared and can therefore be used to trigger other steps in your pipeline or to make sure that the data in Snowflake is up to date.
The use of a summary table is enabled by checking the following option that can be found under Advanced when creating/editing the Share in Funnel.
Funnel account ID
Unique Funnel Share configuration
Unique ID for a single sharing job
Files that failed to be shared
Files that were shared successfully
Status of the sharing job, 'Success' or 'Fail'
UTC timestamp of when the sharing job started
UTC timestamp of when the sharing job ended
Status message from failed sharing job
Files in a sharing job
Status of file sharing, 'Success' or 'Fail'
Status message from failed file sharing
If the file changed, true or false
Query bytes per export run
SUM(value['file_size_bytes']) as bytes
LATERAL FLATTEN( input => files )
GROUP BY run_id;
List export run part statuses and error messages
value['status'] as status,
value['message'] as message
LATERAL FLATTEN( input => files );
Query the number of failed/successful export jobs per day
DATE(end_at) as date,
SUM(total_count) as total_total,
SUM(success_count) as success_total,
SUM(fail_count) as fail_total