• Documentation
    • Search documentation
    karat

    +

    K

    API Reference ↗
    Data connectivity & integrationSQL in FoundryOverview

    SQL in Foundry

    Foundry supports SQL queries against both tabular data and ontology object types, using a common Spark SQL dialect. SQL is available from the dedicated SQL Studio application, the embedded SQL console in supported applications, and external SQL clients connected via Arrow Flight SQL or the SQL REST API.

    Capabilities

    SQL in Foundry enables you to:

    • Query tabular data using standard SQL syntax powered by the Furnace engine.
    • Query ontology object types using the Ontology SQL engine.
    • Create and modify tabular data.
    • Author Ontology SQL functions (beta).
    • Run quick contextual queries using the embedded SQL console.
    • Connect external tools to query Foundry resources with SQL.

    Getting started

    To get started with SQL in Foundry:

    1. Learn the fundamentals by reviewing the SQL dialect documentation, along with the Furnace and Ontology SQL engine overviews.
    2. Open the SQL editor, either via SQL Studio or the embedded SQL console in supported applications.
    3. Run your first query referencing SQL examples.
    4. Connect external tools using Arrow Flight SQL.

    For details on the roles and permissions that govern SQL access, see SQL permissions.