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

• SQLite engine
• sqlite table function