• Documentation
    • Search documentation
    karat

    +

    K

    API Reference ↗
    Data connectivity & integrationSQL warehousingOverview

    SQL warehousing [Beta]

    Beta

    The ability to create and modify tables via SQL warehousing is in the beta phase of development and may not yet be available on your enrollment. Contact Palantir Support to request access.

    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.

    Capabilities

    SQL warehousing enables you to:

    • Query datasets interactively using standard SQL syntax in SQL preview.
    • Create and modify data (beta) 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 navigating to any dataset and opening the SQL preview tab.
    3. Run your first query following the examples in SQL warehousing in Foundry.
    4. Connect external tools using the Arrow Flight SQL JDBC driver.