Dataverse: introducing the new Elastic tables
Image Source: Shutterstock.com
Microsoft Dataverse
Jun 1, 2023 10:00 AM

Dataverse: introducing the new Elastic tables

by HubSite 365 about Stefano Demiliani [MVP]

Citizen DeveloperMicrosoft DataverseBuild 2023M365 Hot News

I don’ know if you have yet discovered that, but some days ago a new table type option called Elastic appeared on Dataverse when creating a new table object: If

More about Dataverse: introducing the new Elastic tables

What are Elastic Tables?

Elastic tables are a new type of Dataverse tables physically stored in Azure Cosmos DB, while standard Dataverse tables are stored on Azure SQL. Elastic tables automatically scale horizontally to handle large amounts of data and high levels of throughput with low latency, which makes them suitable for applications with unpredictable, spiky or rapidly growing workloads. When creating a new table object in Dataverse, users can select the new Elastic table type, which comes with some limitations on what can be done.

Advantages of Using Elastic Tables

Elastic tables offer several advantages over standard Dataverse tables. They are able to scale automatically, so users don’t have to worry about scalability or performance issues. They also have low latency, meaning that data is returned quickly, and they can handle unpredictable, spiky or rapidly growing workloads. Additionally, they are much more cost-effective than standard Dataverse tables, as they require fewer resources and less maintenance.

How to Use Elastic Tables

Using Elastic tables is relatively straightforward. After creating a new table object in Dataverse, users can select the new Elastic table type. After this, they can use the standard Dataverse operations to work with their tables, such as creating, retrieving, updating, and deleting data. Users can also use the Azure Portal to monitor their Elastic tables and manage their capacity.

Conclusion

Elastic tables offer several advantages over standard Dataverse tables, including lower latency, scalability, and cost-effectiveness. They are also relatively easy to use, as they can be managed using the standard Dataverse operations. For applications with unpredictable, spiky or rapidly growing workloads, Elastic tables are an ideal solution.

More links on about Dataverse: introducing the new Elastic tables

Dataverse: introducing the new Elastic tables
5 days ago — Elastic tables (actually in preview) are a new type of Dataverse tables physically stored in Azure Cosmos DB (while standard Dataverse tables ...
What's the new table type being introduced..?
May 21, 2023 — Elastic tables are new tables which came in to Dataverse and probably it will be announced in the upcoming Microsoft Build 2023. From my view, ...
What's the new table type being introduced..?
May 21, 2023 — Elastic tables are new tables which came in to Dataverse and probably it will be announced in the upcoming Microsoft Build 2023. From my view, ...
Dataverse: introducing the new Elastic tables
Dataverse: introducing the new Elastic tables.
Microsoft Dataverse: Going from Excel to new AI-powered ...
May 23, 2023 — The new elastic tables in Dataverse can handle large volumes of non-relational data, up to ingesting tens of millions of rows an hour.
Dataverse Table Types
Feb 10, 2021 — However, understanding the tables types is essential to understand the how-to benefit of those tables and how to introduce new custom tables ...