Malloy vs Tableau

Malloy is an open source language for describing data relationships and transformations. Users can define reusable calculations, table relationships and business logic in semantic models, then compile queries into SQL optimized for the connected database. The language supports nested datasets and automatically guards against common errors in sums, averages and counts. Supported databases include DuckDB, MotherDuck, BigQuery, Databricks, Snowflake, PostgreSQL, MySQL, Trino and Presto. DuckDB can read Parquet, CSV and JSON files without additional setup. Malloy offers a Visual Studio Code extension for modeling, querying, transformation and visualization, plus a browser notebook through github.dev that requires a GitHub sign-in. Its Python package loads models, compiles queries and runs statements with DuckDB and BigQuery. The CLI can run Malloy files, build persistent tables and automate transformations and pipelines. The project is free and open source, with web, editor extension, API and self-hosted options, among others. DuckDB connections can disable network access; sandboxed mode also limits file access to allowed directories.

Tableau is a data analytics platform for dashboards, visualizations, and data apps. It offers hosted cloud and self-hosted server deployments, with hybrid deployment listed. Tableau Creator can connect to any type of data. Users can ask natural-language questions for AI-powered insights, while Tableau Agent provides conversational analytics inside dashboards. A knowledge engine and semantic layer support consistent metrics. Teams can publish, author, share, schedule subscriptions, and send notifications. Tableau Cloud supports secure sharing; row-level security, embedded analytics, and real-time refresh are listed. Viewer includes mobile access. Dashboards and data apps can operate across Slack, Teams, Claude, ChatGPT, CRM, and agent surfaces. Tableau has a free plan and free trial, and Tableau Desktop is free to download. Listed annual-billing prices are $15 a month for Viewer, $42 a month for Explorer, and $75 a month for Creator. Enterprise prices are also listed, while some paid pricing requires contacting sales.