Technologies tagged with "Sql"

Power BI is Microsoft's business intelligence platform — free Windows authoring in Power BI Desktop, publishing and sharing through the Power BI service at a per-user price, and an on-premises Report Server for organisations that cannot publish to the cloud.

Tableau is Salesforce's business intelligence platform, licensed by role — Creator, Explorer, Viewer — and deployable either as the hosted Tableau Cloud or as Tableau Server on the customer's own Windows or Linux machines.

Looker is Google Cloud's business intelligence platform, built around LookML — a version-controlled modelling language in which metrics and joins are defined once and every dashboard, explore, and API call is generated from that definition rather than from ad-hoc SQL.

Amazon Quick Sight — until October 2025, Amazon QuickSight — is AWS's serverless business intelligence service, billed per user or per session, with SPICE, its in-memory engine, caching data for dashboards that must stay fast without hammering the source.

Sigma is a cloud analytics platform whose interface is a spreadsheet: business users pivot, filter, and add formulas against live warehouse tables, with input tables writing values back into the warehouse rather than into a local file.

Lightdash is an open-source BI platform that builds its semantic layer directly from a dbt project — dimensions and metrics are declared in the dbt YAML an analytics team already maintains, and every chart and dashboard is generated from those definitions.

Evidence is an MIT-licensed framework that builds business intelligence from plain files: SQL queries and charts are written inside markdown, and the project compiles to a static website that can be deployed anywhere a static site can.

Rill is an Apache-2.0 BI tool distributed as a single Go binary: metrics and dashboards are defined in SQL and YAML in a local project, served by an embedded DuckDB or a connected ClickHouse, and deployed to Rill Cloud when they are ready to share.

Redash is a BSD-licensed query-and-dashboard tool: analysts write SQL against any connected source, turn results into visualisations, assemble them into dashboards, and share them — running entirely on the team's own infrastructure, with no commercial edition to upgrade to.

SQLMesh is a data transformation framework from Tobiko Data that runs SQL and Python models with a plan-and-apply workflow, column-level lineage, unit tests, and virtual data environments that let teams preview changes without rebuilding tables.

Dataform is a service for developing, testing, version-controlling, and scheduling SQL transformation workflows in BigQuery, built on an Apache-2.0 meta-language and offered on Google Cloud at no charge beyond the BigQuery it runs.

Coalesce is a commercial transformation platform that builds warehouse pipelines from reusable metadata-driven nodes and templates rather than hand-written SQL, with column-level lineage, cataloging, and quality checks in one managed service.

Bruin is an open-source data pipeline tool written in Go that combines ingestion, SQL and Python transformations, automated quality checks, and column-level lineage in a single CLI, with a managed cloud layer above it.

Presto is a distributed SQL query engine for federated analytics, governed by the Presto Foundation under the Linux Foundation, whose members include Meta, IBM, Uber, and Nvidia — the original codebase that PrestoSQL forked from before renaming itself Trino.

Apache DataFusion is an extensible query engine written in Rust that uses Apache Arrow as its in-memory format, shipped as libraries for building database and analytic systems rather than as a server to run.

Amazon Athena is a serverless interactive query service that runs SQL directly against data in Amazon S3, with no infrastructure to provision and a bill computed from the data each query scans.

Starburst is the commercial platform built on Trino, sold as Starburst Enterprise for self-managed clusters and Starburst Galaxy as a fully managed service, adding governance, performance work, and a supported Iceberg lakehouse on top of the open-source engine.

Dremio is a SQL engine for the lakehouse that federates queries across Iceberg, Delta Lake, databases, and warehouses, and accelerates them with materialised structures it calls Reflections — available as a free Community edition, a self-managed Enterprise edition, and a managed cloud service.

Apache Hive is a distributed, fault-tolerant data warehouse system that enables analytics at massive scale, running SQL over data in the Hadoop ecosystem on Apache Tez, with LLAP for sub-second queries and first-class Apache Iceberg support in the 4.x line.

RisingWave is a PostgreSQL-compatible streaming database that maintains materialized views incrementally rather than recomputing them, storing state and tables in object storage so compute and storage scale separately.

Materialize incrementally updates SQL results as data arrives rather than recomputing them, built on Timely and Differential Dataflow and reachable over the PostgreSQL wire protocol, with strict serializability by default.

Azure Stream Analytics is a fully managed stream processing engine using a SQL dialect extended with temporal constraints, running in the cloud or on IoT Edge with the same tools and query language.

Arroyo is a distributed stream processing engine written in Rust that defines pipelines in SQL, performing stateful computation over bounded and unbounded sources with event-time processing and watermarks.

Striim is a commercial real-time data integration platform combining change data capture with streaming SQL, moving data from operational databases and SaaS applications into warehouses, lakehouses, and Kafka as it changes.

DuckLake is an integrated data lake and catalog format from the DuckDB Foundation that stores table metadata in an ACID SQL database rather than in files, with data in Parquet on object storage.

Apache Druid is a real-time analytics database combining ideas from data warehouses, time-series databases, and log search systems, with columnar storage, time-based partitioning, and bitmap indexes serving sub-second queries over streaming data.

Apache Doris is an MPP analytical database for real-time reporting and ad-hoc analysis, speaking MySQL-compatible SQL over a Java front end and a C++ back end, and the project StarRocks was originally forked from.

SingleStore is a commercial distributed SQL database that runs transactional and analytical workloads in one engine, combining rowstore and columnstore tables with vector search, and delivered as the managed Helios service or self-managed.

Tinybird is a managed ClickHouse platform that turns a SQL query into a deployed HTTP endpoint, aimed at developers building real-time analytics into applications rather than operating a database.

TimescaleDB is a PostgreSQL extension that adds automatic time-based partitioning, hybrid row-columnar storage, and incrementally refreshed aggregates, keeping full PostgreSQL SQL and its entire ecosystem of drivers and tools.

QuestDB is an open-source time-series database with a column-oriented, time-partitioned storage engine and SIMD-vectorized execution, extending SQL with time-series operators like SAMPLE BY and ASOF JOIN.

CrateDB is an open-source distributed SQL database for real-time analytics and search, querying relational, JSON, time-series, geospatial, vector, and full-text data through one PostgreSQL-compatible interface.

GreptimeDB is an open-source observability database handling metrics, logs, and traces in one Rust engine, with columnar storage on object storage and both SQL and PromQL as query languages.

Amazon Redshift is AWS's managed analytical data warehouse, offering provisioned RA3 clusters with managed storage or a serverless mode that scales compute automatically and bills per second.

Databricks SQL is the warehousing surface of the Databricks platform, running BI and analytical SQL on the vectorized Photon engine against Delta Lake and Iceberg tables governed by Unity Catalog.

Microsoft Fabric Warehouse is the relational warehouse item in Microsoft Fabric, offering full T-SQL with multi-table ACID transactions over Delta tables held in OneLake and billed against a shared Fabric capacity.