Table engines for integrations

ClickHouse provides various means for integrating with external systems, including table engines. Like with all other table engines, the configuration is done using CREATE TABLE or ALTER TABLE queries. Then from a user perspective, the configured integration looks like a normal table, but queries to it are proxied to the external system. This transparent querying is one of the key advantages of this approach over alternative integration methods, like dictionaries or table functions, which require the use of custom query methods on each use.

<!-- The table of contents table for this page is automatically generated by https://github.com/ClickHouse/clickhouse-docs/blob/main/scripts/autogenerate-table-of-contents.sh from the YAML front matter fields: slug, description, title. If you've spotted an error, please edit the YML frontmatter of the pages themselves. --> <!--AUTOGENERATED_START--> <!--AUTOGENERATED_END-->