Background

To be able to get an overview of historical jobs and the latest status you can also create an 'export summary' table from your BigQuery Share in Funnel. If you have multiple Shares targeting the summary table, these entries will be appended.
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.

Table Schema

Field name	Type	Mode	Description
account_id	STRING	NULLABLE	Funnel account ID
export_id	STRING	NULLABLE	Unique Funnel Share configuration
run_id	STRING	NULLABLE	Unique ID for a single sharing job
total_count	INTEGER	NULLABLE	Files shared
fail_count	INTEGER	NULLABLE	Files that failed to be shared
success_count	INTEGER	NULLABLE	Files that were shared successfully
status	STRING	NULLABLE	Status of the sharing job, 'Success' or 'Fail'
start_at	TIMESTAMP	NULLABLE	UTC timestamp of when the sharing job started
end_at	TIMESTAMP	NULLABLE	UTC timestamp of when the sharing job ended
message	STRING	NULLABLE	Status message from failed sharing job
files	RECORD	REPEATED	Files in a sharing job
files. file_name	STRING	NULLABLE	Name of the shared file
files. status	STRING	NULLABLE	Status of file sharing, 'Success' or 'Fail'
files. message	STRING	NULLABLE	Status message from failed file sharing
files. updated	BOOLEAN	NULLABLE	If the file changed, true or false

Example Queries

List all files and statuses

SELECT
  file.file_name,
  file.status
FROM
  `export_summary`,
  UNNEST(files) AS file
ORDER BY
  end_at DESC

Number of Failed/Successful sharing jobs per day

SELECT
  DATE(end_at) as date,
  SUM(total_count) as total_total,
  SUM(success_count) as success_total,
  SUM(fail_count) as fail_total,
FROM
  `export_summary`
GROUP BY
  1
ORDER BY
  1 DESC

Google BigQuery summary table

Background

Table Schema

Example Queries