I am doing Oracle to Snowflake Table Migration Using Matillion. I have used Database Query Component to Load Data From oracle to Snowflake. But the Columns which contain Varchar2 in oracle table, when queried in Matillion Database query component the Fields are coming empty as Varchar2 is not in Snowflake, is there any way around ?
Hi @biswasmitlenka
I have a couple of questions if that's okay? Can you confirm what values you were expecting to see and are other fields from the same table being extracted correctly? You should be able to sample the data before running. Is the component validating correctly?
Many thanks,
Claire