Apache Superset vs Looker

Apache Superset is a free, open-source platform for exploring data and creating visualizations. Users can build charts with a no-code tool or work in a SQL IDE, then assemble charts and tables into interactive dashboards with drag-and-drop tools. It includes more than 40 visualization types and supports custom visualizations through plug-ins. Dashboard features include filters, cross-filters, drill-to-detail, and drill-by; other listed tools include caching, Jinja templating, CSS templates, and a semantic layer. The database guide lists 81 supported databases, with each engine requiring a separately installed driver; examples include Trino, Apache Hive, Apache Spark SQL, PostgreSQL, and Google BigQuery. Superset is self-hosted and can be installed through Docker Compose, Kubernetes, or as a Python package from PyPI. Kubernetes is described as the production best-practice option and requires Kubernetes expertise. Superset also lists row-level security, scheduled reports, embedded analytics, and natural-language queries. Its OpenAPI-specification REST API supports automation and integrations, and most endpoints require JWT authentication. Community support is available through Slack, GitHub, a mailing list, and meetups.

Looker helps organizations explore, share, and visualize company data for business decisions. Its LookML semantic models define dimensions, aggregates, calculations, and relationships, then use those definitions to generate SQL queries. Gemini-powered natural-language analytics lets users ask questions, while Dashboard Agents provide summaries and explorations grounded in governed metrics. Looker connects to BigQuery, Spanner, Cloud SQL for MySQL, Cloud SQL for PostgreSQL, and other Google services. The Looker Marketplace offers applications, prebuilt LookML models, visualizations, and actions for delivering data to third-party services. Listed capabilities include hourly refresh, row-level security, scheduled reports, and embedded analytics. Deployment is hybrid, with web, Android, iOS, API, and self-hosted options. Mobile apps let users view Looks and dashboards. Google documents TLS 1.2 or later for data in transit and AES-256 encryption for locally stored sensitive application data. A free 14-day trial is advertised, but there is no free plan. Standard, Enterprise, and Embed each list one production instance, 10 Standard Users, and two Developer Users; their API call allowances differ. Pricing is on request.