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:

1. Access your destination (for this example, we are using BigQuery)
2. 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;