โ11-06-2020 10:45 AM
Snowflake Bulk Load is giving error
Cannot find table : โschemanameโ.โtablenameโ, reason=Table does not exist in the database, resolution=Ensure the provided table exists in the database.
If I change use Snowflake Insert Snap in place of Snowflake Bulk Load snap it is working fine. I am not sure why Snowflake Bulk Load is giving error. These pipelines were working fine couple of days back
โ11-08-2020 11:01 PM
Hi @erkonline,
In the properties of the snap, check what you have:
Iโve noticed that โKMS keyโ is fulfilled with something that I havenโt input. Just remove it in case.
Also, check the other properties having โFileโ in the name, so if something exists that you didnโt input, also remove.
What browser do you use? Iโve noticed also that if you use an inappropriate browser those get fulfilled.
You should use Chrome.
If that doesnโt work, then delete the snap and add a new one with the same settings.
/Igor
โ11-09-2020 06:57 AM
Thanks for the reply. I have tried all the options. There was nothing in the marked fields and still cleared them and also deleted and added the snap but no luck. I am using Chrome browser.
โ11-09-2020 07:57 AM
The error message that you receive is very straightforward. Just check if the names are put in an expression or for some spaces in the end which can result in a non-existing table name.
I use the โBulk Loadโ snap with Snowflake and it works on my side. I hope itโs something trivial on your side.
/Igor