[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