Introduction

Find out how you can retrieve all the events synced from the Fivetran connector that belong to Dashboard activity.

Environment

Connector: Fivetran Log

Steps

You can achieve this by querying the Fivetran Log connector (which is free). You can find out which events Fivetran generates for Dashboard activity in our Log Events Documentation.

Use the following query to see those in your destination:

SELECT *
FROM `prd-ocd-ot-data.fivetran_log.log`
WHERE message_event in ('change_schema_config', 'connect_bi_tool',
'update_bi_tool', 'disconnect_bi_tool',
'create_connector', 'edit_connector',
'delete_connector', 'pause_connector',
'resume_connector', 'resync_connector',
'resync_table', 'force_update_connector',
'dismiss_warning', 'update_logger',
'pause_logger', 'resume_logger',
'disconnect_logger', 'signin_warehouse',
'signout_warehouse', 'update_warehouse',
'delete_warehouse', 'test_connection',
'upload_file', 'create_file_upload_table',
'remove_file_upload_table', 'add_user',
'remove_user', 'update_user',
'create_transformation', 'update_transformation',
'delete_transformation', 'diagnostic_access_approved',
'diagnostic_access_denied', 'diagnostic_access_revoked'
)