Hello,
I have a process to load million of data from one snowflake table to another snowflake table (possibly from different Databases within Snowflake due to security and sensitive data). Both the source and the target table has almost 300 columns. Since it has millions of data, I am using ELT Snaps to keep the process Native as target execution will be done directly in Snowflake.
I have set the Load action to "Drop and Create table" in the ELT Load Snap settings as this is similar to Truncate and Load.
I am using ELT Load Snap to load from source to Target, but I am getting the below error as provided in the scrennshot as "Failure: Invalid Source Location, Reason: Source Location in Account seems None, Resolution: Provide a valid Source Location"
Why is the ELT Load snap is failing and possible solution for that.
Below is the screeshot of the Pipeline.
I could have Truncate the target table process outside the ELT process and used the "ELT MERGE INTO" Snap, but the reason for not using that is that i have to mention all the 300+ columns in the "ELT MERGE INTO" snap and it is very tedious and not sustainable as the source and target table could grow in columns and this will lead to change in the pipeline for ELT MERGE INTO snap everytime there is a change in columns.
Thanks
Aravind N
