While you may have noticed this or not, but it’s real. Now Dynamics 365 CE existing table types have a new companion called Elastic, it is yet to be announced.
However let’s take a quick look of the table types showing up when you were trying to create a new one in Dataverse.
While everyone is aware about Standard, Activity, Virtual types in Model Driven Apps. 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, Elastic tables were
1. Built similar to the concept of Elastic Queries in Azure which is usually meant for the purposes of Data archiving needs.
2. You can scale out queries to large data tiers and visualize the results in business intelligence (BI) reports.
3. Elastic Query provides a complete T-SQL Database Querying capability on Azure SQL, possibly Dataverse.
Hope we get all the capabilities released with Elastic Queries of Azure SQL be released in Dataverse as well.
Data Types in Model Driven Apps