SQLite
Not supported in ClickHouse Cloud
The engine allows to import and export data to SQLite and supports queries to SQLite tables directly from ClickHouse.
Creating a Table
Engine Parameters
db_path— Path to SQLite file with a database.table— Name of a table in the SQLite database.
Usage Example
Shows a query creating the SQLite table:
Returns the data from the table:
See Also