Supply: Shutterstock
As enterprises proceed to embrace cloud-based analytics, the want for sturdy semantic layers is turning into more and more evident. It helps organizations with knowledge entry, ensures consistency throughout BI instruments, and enforces robust governance and safety. A common semantic layer could possibly be the key to unlocking worth from enterprise knowledge. .
To fulfill the rising want for higher analytics, AtScale and Dice have introduced new integrations. AtScale is strengthening its partnership with Snowflake by working with Cortex Analyst to allow pure language SQL queries. Dice is enhancing its help for Microsoft by including direct integrations for Energy BI and Excel.
AtScale and Snowflake Deliver AI-Powered Pure Language Queries to BI
With its integration into Snowflake Cortex Analyst, AtScale brings a governance layer to AI-generated SQL queries. This ensures the queries match enterprise definitions and keep correct.
The mixture of Snowflake’s pure language processing and AtScale’s semantic layer reduces ambiguity in question outcomes whereas enhancing efficiency. Additionally, AtScale’s optimization engine enhances efficiency by automating knowledge processing and decreasing the load on Snowflake’s cloud knowledge warehouse.
AtScale additionally supplies security measures, like object and row-level safety, to verify AI-generated insights comply with firm insurance policies. These mixed capabilities assist non-technical customers work with knowledge simply whereas nonetheless getting dependable, safe, and quick outcomes for large knowledge evaluation.
Snowflake sees the mixing as a means to enhance the standard and accuracy of knowledge queries. “Our integration with AtScale improves the standard of the semantic layer that sits between the person’s question and the underlying knowledge,” stated Abhinav Vadrevu, Senior Product Supervisor at Snowflake.
“This in the end results in vital enhancements in textual content to SQL high quality. By combining Cortex Analyst with AtScale’s semantic layer, customers can get right solutions in seconds. In the end, this protects hours on guide SQL verification, resulting in a lot sooner time to perception.”
The important thing advantages of the AtScale and Snowflake Cortex Analyst integration embrace higher alignment between AI-driven queries and outcomes from BI instruments. This consistency helps companies belief their knowledge, to allow them to make higher selections with out worrying about variations within the outcomes.
The mixing between AtScale and Snowflake Cortex Analyst builds on AtScale’s earlier efforts to enhance pure language queries and knowledge governance.
In September 2024, AtScale launched the open-source Semantic Modeling Language (SML) to reinforce semantic mannequin portability and foster a vibrant group of mannequin builders. Later within the 12 months, AtScale launched a public leaderboard for Textual content-to-SQL options to set clear requirements for evaluating pure language queries.
Dice Launches Dice Cloud for the Microsoft Enterprise
The deeper integration with the Microsoft ecosystem strengthens Dice Cloud’s position as a supplier of a common semantic layer for Microsoft enterprises.
Dice is introducing two main upgrades to its Microsoft integrations. The primary is the Information Evaluation Expressions (DAX) API for Energy BI, by means of which customers can join natively from Energy BI to Dice and question Dice knowledge fashions in actual time. This setup provides customers reside entry to knowledge in cloud warehouses like Databricks and Snowflake from Energy BI whereas retaining all of the highly effective options of the DAX question language.
The opposite vital enhancement is the Dice Cloud for Excel Add-In that connects to ruled knowledge with Excel desktop or Excel on-line. Dice claims that the customized interface permits customers to type and filter by means of the info and replace their evaluation with a single click on.
As an alternative of manually exporting or taking snapshots of knowledge for evaluation, Dice’s MDX API and Excel Add-in present real-time connections to cloud datasets. This minimizes inefficiencies and outdated data.
“Enterprises are quickly adopting cloud knowledge platforms like Microsoft Azure, Snowflake, and Databricks,” stated Artyom Keydunov, CEO and Co-Founding father of Dice. “Nonetheless, the shift to the cloud has left many organizations with no trendy OLAP resolution for multidimensional evaluation that may combine with a broad ecosystem of knowledge consumption instruments.”
“In the present day, we’re excited to announce our native integrations with Excel and Energy BI. With our new DAX API, enterprises can question knowledge reside, with out extracts, in cloud knowledge warehouses, akin to Snowflake and Databricks, instantly from Energy BI.”
Previous to this launch of Dice Cloud for the Microsoft Enterprise, Dice had been progressively enhancing its integrations throughout the Microsoft ecosystem. In mid-2024, Dice introduced compatibility with Microsoft Entra ID (previously Azure Energetic Listing), enabling enterprises to supply single sign-on experiences for customers accessing Dice Cloud. These efforts replicate Dice’s continued enlargement throughout the Microsoft analytics ecosystem.
Associated Gadgets
Dice Deepens Semantic Hooks Into GCP, Holds First Convention
Semantic Layer Belongs in Middleware, and dbt Needs to Ship It
Dice Secures $25M to Advance Its Semantic Layer Platform