Can we create Common table expression (Tables) through matillion Transformation
Hi @indiankita02,
The answer to your question is that it depends on how you are used to using CTE's. In transformations you can use the "SQL" component and that will allow you to leverate CTE's. If you are used to being pretty deep into CTE's where multiple CTE's are used and may build on top of each other, a different tool Dbt could be a better approach. I have found that senior devs that have a deep knowledge or SQL tend to fall back to Dbt because it leverages what they know quite well. Matillion is great for those that don't necessarily have that deep SQL knowledge but still have a needs to transform data. The components that Matillion provides can get the user to the same place. It may just take more steps and have more moving parts. I hope this helps!