Arrow Flight SQL ↗ is a protocol for interacting with SQL servers. Arrow Flight SQL uses the Apache Arrow in-memory format and Flight RPC protocol for efficient and portable data transfer.
Foundry implements the Arrow Flight SQL protocol, meaning that any Flight SQL client can connect to Foundry, enabling many third-party connections without the need for custom configuration.
Arrow Flight SQL offers a JDBC driver ↗ that can be used with any JDBC-based client application, such as DBeaver ↗, DataGrip ↗, or others. Follow the instructions below to set up and use the JDBC driver in Foundry.
Download the JDBC driver (.jar file) ↗. Once downloaded, place the file into the appropriate location as specified in the client application's documentation for configuring JDBC connections.
The JDBC connection string format is:
jdbc:arrow-flight-sql://<FOUNDRY_HOSTNAME>:443/?token=<TOKEN>
FOUNDRY_HOSTNAME is the hostname of your Foundry environment (such as subdomain.palantirfoundry.com).TOKEN is a security token generated from the Settings page inside Foundry. See the user-generated tokens documentation for instructions on how to obtain a token.If the JDBC client requires a username and password to be specified, specify the username to be token and the password to be a user-generated token.
If the JDBC client requires the driver class to be specified explicitly, specify org.apache.arrow.driver.jdbc.ArrowFlightJdbcDriver.
If supported by the client application, test a SQL query that returns rows from a Foundry dataset:
Copied!1SELECT * FROM `/Path/To/Dataset` LIMIT 10
The client application may instead allow you to browse projects and select datasets to access data.
For the full set of JDBC connection parameters, see the Flight SQL documentation ↗.