Question
How can I see my Monthly Active Row (MAR) usage per table and day?
Environment
Connector: Fivetran Log
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
- 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;