ClickHouse custom transformation

We currently have a MySQL to ClickHouse connection and we use basic transformation. However, we need some custom transformation namely we need to transform epoch times to Unix timestamps.

I went through the documentation and read about dbt transformation, but I don’t see the custom transformation section below the basic transformation.

Would you please help me with how we could reach this goal?


Hey @arashlayeghi,
The tutorial you linked explains how to set up a custom transformation after you locally built one with DBT.
This tutorial explains how to export the generated basic normalization DBT project . You can tweak this code to make the change you need and use this DBT project as your custom transformation.
Let me know if it answers your question.

Hey @alafanechere,
Thanks for the quick response.
My question was why I don’t see a custom transformation section on this page?
Assuming I’ve created the custom normalization with DBT how can I use that project here where I cannot see the custom normalization you depicted in the documentation?
We use ClickHouse destination.

What I see:

What you displayed on your documentation:


Oh, I get it now.
We disabled support of custom transformation on ClickHouse some months ago because it was bugged.
Please leave a thumb-up on this issue and we’ll try to re-enable it.

Hi there from the Community Assistance team.
We’re letting you know about an issue we discovered with the back-end process we use to handle topics and responses on the forum. If you experienced a situation where you posted the last message in a topic that did not receive any further replies, please open a new topic to continue the discussion. In addition, if you’re having a problem and find a closed topic on the subject, go ahead and open a new topic on it and we’ll follow up with you. We apologize for the inconvenience, and appreciate your willingness to work with us to provide a supportive community.