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?
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.
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.