io_config.yaml
.default
(you can
have multiple profiles, add it under whichever is relevant to you)SQL
.Data provider
dropdown, select ClickHouse
.Profile
dropdown, select default
(or the profile you added
credentials underneath).Write policy
dropdown, select Replace
or Append
(please see
SQL blocks guide for more information on write policies).SELECT 1
.Generic (no template)
.config_profile
from default
if
you have a different profile):Write policy
is set
to Replace
, data exporter
will automatically create a table in ClickHouse
with Engine = Memory
and a default schema inferred from the data.
However, this may not be optimal for various use cases. Since table creation
in ClickHouse
can involve numerous details, it is strongly advised to
create the destination table manually before loading data to ensure it
meets specific requirements.
If generating the destination table via Mage export method, one can ovewrite specific column types
by using the overwrite_types
dict setting.
Example: