[Wranglers] Databases that added support for Translytical workloads in 2024
Ali, Saqib
docbook.xml at gmail.com
Sat Jan 11 00:47:56 UTC 2025
Here are three databases that added support for translytical workloads in
2024:
1. SQL DB in Microsoft Fabric. All data is replicated in near-real time
to open-source delta parquet format in OneLake. When you deploy a SQL
database in Fabric, you get two endpoints: an endpoint to the database and
a “SQL analytics endpoint” that allows querying the replicated data in
OneLake. This unifies operational and analytics work without having to move
any data. With the SQL analytics endpoint, you can query using the data
warehouse engine.
2. TiDB. Real-time replication of data from OLTP Table to Columnar
TiFlash tables. Analytical queries are served by the TiFlash Columnar
tables.
3. AlloydDB. Enable the Columnar Engine on the AlloyDB and then either
manually add columns to the Columnar Engine or use auto-columnarization,
which analyzes your workload and automatically adds columns.
Saqib
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://analyticsengineering.net/pipermail/wranglers/attachments/20250110/5ed5307b/attachment.htm>
More information about the Wranglers
mailing list