You want to see your Monthly Active Rows (MAR) based on specific days and tables.
Fivetran Log Connector
- 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
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;