How do I view my Monthly Active Row (MAR) usage per table per day?
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.
Access your destination (for example, BigQuery).
To view your MAR per table per day, execute the following SQL query. Replace
table_namewith 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;