Snowflake unveils AI tools for data analytics, migration
The company announced its expansion of enterprise-grade AI with the introduction of Cortex AISQL and SnowConvert AI, designed to enable customers to extract insights from diverse data types while reducing operational costs and complexity.
Cortex AISQL incorporates generative AI directly into database queries, allowing teams to analyse and act on multiple kinds of data—ranging from structured numbers to text, images and audio—while using the SQL syntax familiar to data professionals. The solution is intended to bring what Snowflake describes as "industry-leading performance and up to 60% cost savings when filtering or joining data." Organisations such as Hex, Sigma, and TS Imagine are among those already leveraging the capabilities of Cortex AISQL.
SnowConvert AI addresses a common challenge faced by enterprises: moving data from existing warehouse and analytics platforms to modern systems. The tool uses AI automation to ease migrations from providers such as Oracle, Teradata, and Google BigQuery, reducing the need for manual re-coding and lowering the risks typically associated with large-scale data projects.
"Every organization recognizes the potential of AI. But too often, harnessing AI means overcoming complex infrastructure, performance limitations, high costs, and a reliance on engineers to build custom pipelines. We're removing those barriers, whether it's enabling anyone to analyze and act on all their data with Cortex AISQL or accelerating migrations off legacy systems through SnowConvert AI. By empowering teams to move faster, work smarter, and turn data into real impact, we're reimagining analytics for the AI era," Carl Perry, Head of Analytics at Snowflake, commented on the new developments.
"In capital markets, speed and precision are everything. For years, SQL has been the gold standard for transforming data — and now, with Cortex AISQL, we're extending that power to unstructured text. With AISQL, our teams can analyze documents, extract insights, and build intelligence directly in the language they already know — all without complex engineering workflows. It's a game-changer for how fast we can respond to markets and deliver value to clients, while leveraging the Snowflake architecture for high performing SQL processing," Thomas Bodenski, Chief Operating Officer of TS Imagine, said, sharing his perspective as a customer.
Snowflake's Cortex AISQL harnesses generative AI—powered by models from providers such as Anthropic, Meta, Mistral, and OpenAI—to introduce advanced query functions into standard SQL. The result is that data analysts can use AI-powered functionalities within the security perimeter of the existing data cloud, without requiring specialist coding or external tools. According to Snowflake, ongoing performance optimisations have demonstrated between 30% and 70% improvements depending on the dataset, and up to 60% cost savings for certain operations.
The integration enables organisations to break down traditional data silos. For example, analysts can merge structured customer data with unstructured data like chat transcripts, images, or social media content, and perform tasks including image classification, call transcript analysis and anomaly detection entirely through SQL queries.
SnowConvert AI, meanwhile, is designed to make IT infrastructure upgrades more efficient, automating code conversion, report migration and data validation to streamline the transition to new platforms. By accelerating the code conversion and testing phases by two to three times, the tool is aimed at reducing the overall timeline and resource demands associated with digital transformation.
Alongside these tools, Snowflake also announced updates to its platform to further support analytics on open source data formats such as Apache Iceberg tables, and launched Standard Warehouse - Generation 2, which introduces hardware and software improvements to boost analytics performance by 2.1 times over previous editions.
With the introduction of these AI-powered features, Snowflake is positioning its data cloud as a central platform for enterprises seeking to modernise analytics and data handling capabilities, and to extract actionable business insights from both structured and unstructured sources.
Hashtags
Try Our AI Features
Explore what Daily8 AI can do for you:
Comments
No comments yet...
Related Articles
Techday NZ
18-07-2025
- Techday NZ
Ataccama ONE v16.2 uses AI to simplify data lineage for business
Ataccama has announced the release of Ataccama ONE v16.2, which brings new AI-driven features to data lineage with the aim of supporting business users in understanding, auditing, and trusting their data. The company stated that the new version addresses long-standing challenges in enterprise data governance, particularly the trust gap between business teams and IT departments. By providing compact, plain-language lineage views and secure on-premises metadata extraction, Ataccama targets the need for transparency in complex data environments. Expanded pushdown profiling capabilities are also included to provide more comprehensive data quality insights. One key issue identified by Ataccama is the limited ability for business users to visualise data origins and transformations without specialist support. The reliance on IT to explain data logic is seen as a barrier to efficient decision-making and increases risk. Recent research from Forrester highlights that only 20% of business decision-makers are currently self-sufficient with analytics tools, suggesting widespread challenges with data access and understanding across industries. The new features aim to close this trust gap by converting complex data workflows into accessible, plain-language descriptions. Business users will be able to track a data point's origin and understand profiling or quality checks independently of technical teams. In real-world settings such as financial services, a data steward can see how a risk score is calculated or how a transaction passes through quality controls, facilitating shorter audits and faster decision-making. "We're seeing enterprise data projects increasingly kick off in the business, not just in IT, and that changes everything," said Jessica Smith, VP of Data Quality at Ataccama. "The teams driving these initiatives need to understand where the data comes from, how it's changed, and whether it can be trusted. That's why we've focused on making complex data processes, like profiling, quality checks, and lineage, clear and usable to everyone. Because if data is going to scale across the business, it has to work for the people who are using it." The company describes several core updates in the v16.2 release. The AI-powered data lineage feature automatically generates readable descriptions showing how data is transformed both upstream and downstream, including filters, joins, and calculations. This makes it possible for business users to see the logic behind datasets without needing to interpret SQL queries. The compact lineage diagrams provide simplified, high-level views of data flows, with the option to explore detailed steps as needed. This feature is designed to help teams identify issues, respond to audit requests, and align stakeholders on data processing practices across the organisation. Edge processing for secure lineage is another new capability, enabling companies to extract metadata from on-premises or restricted environments without transferring sensitive data to the cloud. Ataccama states that this functionality helps organisations to maintain compliance, reduce risk, and maintain full visibility into their data pipelines, regardless of their infrastructure. The update also expands pushdown support and performance for data profiling and quality workloads. Users can now run these tasks in pushdown mode for platforms such as BigQuery and Azure Synapse, minimising data movement and enhancing performance for larger workloads. In addition, volume support for Databricks Unity Catalogue has been introduced to further optimise execution on modern cloud platforms. According to Ataccama, the new version of its data trust platform is intended to strengthen daily data governance while underpinning more scalable and compliant AI and analytics initiatives. The company positions its integrated approach as key to enabling businesses to unlock the value of their data for operational, analytical, and AI-driven purposes.
NZ Herald
17-07-2025
- NZ Herald
On the Up: Power pricing start-up Factor secures $3m, signs first customer across the Tasman
The Wellington-based pair say Factor is delivering a suite of tools – with AI in the mix – that automate what has traditionally been a clunky, spreadsheet-based pricing process for energy retailers, distribution networks and other energy tech companies. 'Simon and I have been working together for a decade. We were part of the founding team at Flick Electric,' Venning-Bryan says, name-checking the upstart electricity retailer that began its life selling power at wholesale rates plus a margin. Flick was sold to Z in 2018 for $46m. Z, in turn, sold Flick to Meridian in May for $70m. 'I was CMO [chief marketing officer] there and Simon was CTO [chief technology officer].' After Flick was sold to Z, Venning-Bryan and Pohlen left to help scale up Flux Federation, Meridian's in-house effort to create billing software (last month, Meridian announced plans to cull 53 jobs from Flux as it entered an outsourcing deal with British firm Kraken). 'In the course of that work, we got to understand the commercial and industrial sector more deeply. We could see there was an opportunity in forecasting and pricing. 'The crux of the problem is that when a utility – and this is globally true – has to provide a price for a commercial customer, which could be anyone from an office building through to a factory through to a farm, those prices are bespoke. They don't come off a generic price book like they might for residential. 'So what happens is they go to a back office pricing team, who almost always use a combination of SQL [database] queries and spreadsheets to come up with a price. It can take a few days or even a few weeks.' And things are getting more complicated as corporate power customers add solar panels to some of their rooftops, and maybe install EV chargers – and in Fonterra's case, electric milk truck chargers – and other points of complexity amid greater electrification. The rise of AI offered the opportunity to quickly gather pricing from legacy systems without power companies having to rip them out. 'We interviewed 30 utilities in 15 markets to validate our own thinking about that opportunity,' Venning-Bryan says. Max Factor To outsiders, coming from a tiny market might seem a disadvantage. But Venning-Bryan says offshore utilities are gobsmacked by the lengths the start-up has had to go to grapple with New Zealand's multi-player market, which has 27 networks. Their pitch: if they can make it work here, they can make it work anywhere. 'We cut our teeth in New Zealand, one of the world's most complex energy markets, with dozens of distribution networks and no standardised meter data format. We built Factor to handle that, and in doing so we built something market-agnostic. That's why we're ready to scale globally,' Venning-Bryan says. Pohlen says Factor can be set up using natural language queries, thanks to technology that builds on Amazon Web Service's Chronos LLM (large language model). Factor has 10 staff, mostly AI experts and data scientists. The new funding will be used in part to expand the team, including sales and marketing roles. Icehouse Ventures chief executive Robbie Paul says Factor's ability to apply modern software design and AI to deeply entrenched industry problems is what drew his attention. 'Just when you think software and AI has eliminated all inefficiencies, in walk great entrepreneurs like Jessica Venning-Bryan and Simon Pohlen optimising a colossal industry like energy,' Paul says. Factor is Icehouse's second early-stage investment announced this week. The firm has raised $16m toward its target $30m for its new Seed Fund IV. Chris Keall is an Auckland-based member of the Herald's business team. He joined the Herald in 2018 and is the technology editor and a senior business writer.
Techday NZ
04-07-2025
- Techday NZ
Devart launches dbForge 2025.1 with AI assistant & new UI
Devart has unveiled dbForge 2025.1, presenting new features including an AI assistant, updated user interface, and expanded connectivity options across its database development tool suite. The new dbForge 2025.1 update introduces the dbForge AI Assistant, offering support for database professionals working with SQL Server, MySQL, Oracle, and PostgreSQL. With this release, Devart aims to address the evolving needs of those developing, managing, and optimising databases. dbForge AI Assistant is described as an AI-powered co-pilot designed to enhance SQL development. Its features include context-aware query generation, natural language conversion to SQL, query optimisation, and advanced troubleshooting for a broad spectrum of database engines. The new functionality seeks to allow users, regardless of their expertise, to interact with databases via natural language while maintaining precise output for complex queries. Oleksii Honcharov, Head of Engineering at Devart, commented on the introduction of the AI Assistant and the wider scope of the update: dbForge 2025.1 isn't just another version, it's a grand step forward for our entire product line. We believe technology should work for you, and with our AI-powered assistant, working with data is a breeze. This means fewer bottlenecks, high-quality answers, and smarter decisions across the board. The AI Assistant is available across the dbForge product family, providing users with several functionalities aimed at accelerating and simplifying SQL development. Amongst its capabilities, the assistant can: Generate context-aware SQL queries by analysing database metadata, without accessing actual data. Convert plain language commands directly into syntactically correct SQL queries, making database access more inclusive for non-experts or those seeking code-free interaction. Optimise existing SQL code with performance suggestions designed for quicker and more efficient queries. Offer explanations that deconstruct complex SQL statements into more comprehensible terms. Troubleshoot problematic SQL queries, diagnosing issues and suggesting or implementing fixes. Conduct error analysis with recommendations that account for the unique requirements and dialects of SQL Server, MySQL, MariaDB, Oracle, and PostgreSQL. Support an interactive chat interface that provides conversational assistance for SQL, general database topics, and dbForge products, removing reliance on separate documentation. The AI Assistant is fully integrated into all editions of dbForge products, including the free Express versions. New users receive a free 14-day trial period for the AI functions. UI and UX upgrades Enhancements to user interface and experience form another key aspect of dbForge 2025.1. The update features a redesigned interface that aims to be cleaner and more intuitive, improving navigation, panel management, and the discoverability of tools. These adjustments arise in response to feedback from users, with the goal of streamlining workflow and reducing potential friction within the application environment. Expanded analysis and compatibility Further improvements have been made to static code analysis capabilities in dbForge Studio for SQL Server and dbForge SQL Complete. The built-in T-SQL Analyzer receives an expanded set of rules, offering more customisation and deeper insight during code reviews. Aligning with evolving cloud integration requirements, dbForge 2025.1 introduces support for dedicated and serverless SQL pools within Azure Synapse Analytics. This enhancement is intended to improve data integration and management workflows for teams who rely on Microsoft's analytics service. Additionally, Devart has updated its support for PostgreSQL tools, which are now compatible with the recently released PostgreSQL 18. This ensures that users are able to leverage new database features as soon as they become available. Product availability dbForge 2025.1 is available for download or update across all core product lines, including dbForge Edge, the Studio series for SQL Server, MySQL, Oracle, and PostgreSQL, as well as dbForge SQL Complete and SQL Tools. Existing users can check for updates within their installed product, while new users may download and trial the full suite of dbForge tools.
