Questionlink
How do I view my Monthly Active Row (MAR) usage per table per day?
Environmentlink
Fivetran Log Connector
Answerlink
Prerequisiteslink
-
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
-
Access your destination (for example, BigQuery).
-
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;