Hello! I have some questions about transformation.
If the source and destination are the same DB type (e.g., the source is Postgres, the destination is also Postgres), can it be made to have the same column data type?
Alternatively, is there a way to receive or check schema (e.g., column type) of the original source DB in the transformation step using the DBT after connection?
Thanks.