How to deal with a SQL which creates a view itself

In-Depth Discussions
1

Hi,

I am using Vertica DB and I have a SQL table. I want to normalize [1] some columns. The problem is that the NORMALIZE () function already creates a view. I would like to know how I should treat this in dbt scenario.

Currently, I have the SQL in order to prepare the table with a post_hook which executes the “normalize()” function.

I think it could be done in some better way. How should I use it ?

Regards