Dashboard subscriptions
A good fit when the recurring workflow is tied to dashboards, questions, charts, and broader BI consumption.
Metabase is a strong choice when the daily workflow lives around dashboards and questions, and the recurring output travels as a subscription attached to a chart. Taavik is a strong choice when the recurring output starts from a saved SQL query, needs to arrive as a CSV or Excel file, and comes from a database that lives behind a firewall. The two products do not compete on BI features. They compete on how the export gets scheduled and delivered.
BI dashboards vs operational exports
Use Metabase when the team needs dashboards, questions, visualization, and BI sharing. Use Taavik when the team already has operational SQL and needs recurring CSV or Excel delivery through a private agent.
A good fit when the recurring workflow is tied to dashboards, questions, charts, and broader BI consumption.
A good fit when the recurring workflow starts from saved SQL and needs a CSV or Excel download link delivered to email or Slack.
The agent executes read-oriented SQL from inside the private network where the database is reachable.
The same workspace keeps generated database documentation and schema change history close to scheduled SQL.
Operational pattern
The shared SQL library stores the query, variables, description, version history, and run audit.
See queriesChoose cadence, timezone, format, and delivery destination for the recurring run.
See schedulesEmail and Slack deliveries include a secure download link for the generated file.
See Slack deliveryChoosing
Finance reconciliation, stuck orders, failed transactions, missing documents, and data quality checks often need recurring row sets more than dashboards. That is the workflow Taavik targets.
FAQ
Metabase has dashboard subscriptions and question alerts, which are the closest thing to scheduled reports in its model. They work well when the recurring output is a dashboard rendered to email or Slack. They fit less well when the recurring output is a plain CSV or Excel file produced by a saved SQL query, which is the workflow this page describes.
Yes. The free plan of Taavik includes one scheduled export, one database connection, and unlimited saved SQL queries. Exports run through the on-premise agent and deliver a secure download link to email or Slack.
The agent runs the saved SQL query at the scheduled time, builds a CSV or Excel file inside the workspace, and delivers a secure download link. Email delivery uses the workspace SMTP; Slack delivery posts the link to a chosen channel through the incoming webhook.
Yes. A parameterized SQL query stores its own defaults, and the schedule can override them per run. A daily failed-payment export can bind the date range to the previous day, while a weekly reconciliation can bind a status filter to a fixed value.
Yes. The agent lives inside the private network and executes the SQL from there, so the cloud workspace never opens a connection towards the database. The row data leaves the network only inside the delivered file, and only once per scheduled run.
PostgreSQL, MySQL, SQL Server, and Amazon Redshift. Provider quirks are handled by the agent; the saved query uses the native dialect of the target database.
Save the SQL, run it through the private agent, and deliver secure download links to the team. The change history of the tables behind the queries is described in the piece on database observability.