Question
How do I see my Monthly Active Row (MAR) usage per table and day?
Environment
Connector: Fivetran Log Connector
Answer
Requirements:
- Fivetran Log Connector
- At least one working connector in your Fivetran account
Note: The Fivetran Log Connector is free and does not count towards MAR
Steps to follow:
- Access your destination (for this example, we are using BigQuery)
- Execute the following SQL query
-- MAR during a month per table, per day.
-- edit dates and tables as needed.
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;