How to Count Daily MAR Usage per Table

Question

How do I view my Monthly Active Row (MAR) usage per table per day?

Environment

Fivetran Platform Connector

Answer

Prerequisites

• Fivetran Platform Connector

• At least one working connector in your Fivetran account

  NOTE: The Fivetran Platform Connector is free and doesn't count towards MAR. For more information about the benefits of the Fivetran Platform connector, see our blog post.

Instructions

1. Access your destination (for example, BigQuery).

2. To view your MAR per table per day, execute the following SQL query. Replace the dates below with your chosen dates.

   SELECT destination_id, connector_id, schema_name, table_name, measured_date, free_type, incremental_rows
   FROM <database_name>.incremental_mar
   WHERE measured_date >= '2020-08-01' AND measured_date < '2020-09-01'
   ORDER BY destination_id, connector_id, schema_name, table_name, measured_date