SQL warehousing

SQL warehousing in Foundry brings powerful, flexible SQL capabilities directly to your data platform. Powered by Furnace, Foundry's modern SQL engine, you can run both read and write SQL operations using an idiomatic Spark SQL syntax in SQL Studio and connected clients.

Capabilities

SQL warehousing enables you to:

• Query datasets interactively using standard SQL syntax in SQL Studio.
• Create and modify data with support for CREATE operations on datasets and for CREATE, INSERT, UPDATE, and DELETE operations on Iceberg tables.
• Connect external tools using the industry-standard Arrow Flight SQL protocol.

Getting started

To get started using SQL warehousing:

1. Learn the fundamentals by reviewing the Furnace architecture and SQL dialect documentation.
2. Try it in Foundry by opening SQL Studio, or by launching SQL console from a dataset context in supported applications.
3. Run your first query following the examples in SQL warehousing in Foundry.
4. Connect external tools using the Arrow Flight SQL JDBC driver.