SQL
Kotlin DataFrame supports reading from SQL databases using JDBC.
Requires the dataframe-jdbc module, which is included by default in the general dataframe artifact and in %use dataframe for Kotlin Notebook. You’ll also need a JDBC driver for the specific database.
Supported databases
Kotlin DataFrame provides out-of-the-box support for the most common SQL databases:
You can also define a Custom SQL Source to work with any other JDBC-compatible database.
Read
DataFrame can be loaded from a database in several ways: a user can read data from a SQL table by given name (DataFrame.readSqlTable()), as a result of a user-defined SQL query (DataFrame.readSqlQuery()), or from a given ResultSet (DataFrame.readResultSet()). It is also possible to load all data from non-system tables, each into a separate DataFrame (DataFrame.readAllSqlTables()).
See Read from SQL databases for more details.