tJDBCSCDELT moving data across different schema in Snowflake
As requirement to move data across different schema in Snowflake using SCD method, the challenge was , how to define different source and target schema where there is option to define only one schema in the configuration by default.
The solution is to not define the schema value against DB Schema and defining it as "".
Where as defining the respective schema before the source and target tables under source table and table configuration. The trick worked !
