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.