> For the complete documentation index, see [llms.txt](https://tricks.bodik.tech/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://tricks.bodik.tech/databases/clickhouse/create-a-connection-to-other-clickhouse-instance.md).

# Create a connection to other ClickHouse instance

This query helps to create a connection to another instance of ClickHouse

To create a remote connection to ClickHouse (CH), you can use a query to specify the necessary connection details, such as the hostname or IP address of the CH server, a username and password for authentication, and the name of the table you want to access.

```sql
select * from remote('host', 'db', 'table','user', 'password');
```