SQL

Queries

Google Sheet Sync History

This query returns the history of Google Sheet syncs across all GSheets-backed Datasets for your workspace.

SELECT
	gss.ORG_USERNAME,
	gss.OBJECT_NAME,
	gss.ID,
	gss.NAME,
	gss.STATE,
	gss.RUNNER_ID,
	gss.GOOGLE_SHEET_ID,
	gs.DATASET_ID,
	gs.CREATOR_ID AS DATASET_CREATOR,
	gs.URL,
	gs.SPREADSHEET_ID,
	gs.WORKSHEET_ID,
	gs.SPREADSHEET_URL,
	gss.STARTED_AT_UTC,
	gss.ENDED_AT_UTC,
	gss.RUNTIME_IN_SECONDS,
	gss.ROWS_RETURNED,
	gss.BYTES,
	gss.IS_SCHEDULED,
	gss.REPORT_SCHEDULE_ID,
	CONCAT(rs.cadence, ' ', rs.cronline) AS GSHEET_SCHEDULES
FROM google_sheet_syncs gss
	JOIN google_sheets gs on gs.id = gss.google_sheet_id
	JOIN datasets ds on ds.id = gs.dataset_id
	JOIN report_schedules rs on rs.report_id = ds.id