How Can I Determine the Number of API Calls Fivetran Made for Each Connector?

Question

How can I determine the number of API calls Fivetran made for each connector over a specified period?

Environment

All connectors

Answer

To see the number of API calls we made daily for each connector, you must add a Fivetran Platform Connector Quickstart data model. See our Add a Quickstart data model documentation for more information. In the fivetran_log__connector_daily_events model, the date_day column reflects the date and the count_api_calls column reflects the number of API calls we made.

To see the number of API calls we made for a specific connector across a specified date range, use the following query:

SELECT sum(count_api_calls) FROM fivetran_log__connector_daily_events
  where connector_id = connector id and date_day between 'start date' and 'end date';