Configuring your ClickHouse destination.
9440
) from the static IP.1024
to 65535
to the static IP.CREATE TEMPORARY TABLE, S3
permissionsThe CREATE TEMPORARY TABLE
and S3
permissions are required to efficiently transfer data to ClickHouse. Under the hood, these permissions are used to stage data in object storage as compressed files, COPY INTO temporary tables, and finally merge into the target tables. By definition, the temporary table will not exist outside of the session.implicit
bucket optionClickHouse supports the ability to configure staging resources with environment credentials. If this setting is enabled on your ClickHouse cluster, you may choose to use the configured implicit staging resources using the implicit
option for the staging bucket selection.database
vs. schema
fields (connection database
vs. write database
)Depending on the version of your integration, you may be asked for both a database
and schema
, or a connection database
and write database
.database
(also referred to as connection_database
): is the database used to establish the connection with ClickHouse.schema
(also referred to as write_database
): is the database/schema within which data will be writtenFINAL
keyword must be used when selecting from these tables guarantee duplicates are removed. For example: