How to Count Daily MAR Usage per Table

Questionlink

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

Environmentlink

Fivetran Log Connector

Answerlink

Prerequisiteslink

• Fivetran Log Connector

• At least one working connector in your Fivetran account

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

Instructionslink

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

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

   select measured_at, table_name, monthly_active_rows
   from `<database_name>.active_volume` 
   and table_name = '<your_table_name>'
   and measured_at >= '2020-08-01' and measured_at < '2020-09-01'
   order by measured desc, table_name desc;