Scheduling data load to snowflake workflow

I currently have setup ODBC connections to Snowflake. I can run a data upload workflow on Designer with no issues by entering my credentials to establish the connection.

However when I try to schedule the workflow in Gallery it fails with an error :

Error SQLPrepare: SQL compilation error: Object "xxxx-xxxxx-xxxx-xxxx" does not exist or not authorised (Tool ID: 6)

I am assuming that it is because there is no way of entering the Snowflake credentials when scheduling in Gallery.

Gallery is currently running on a different host to where Designer is running, current version of both Designer and Gallery is 2019.1.6.58192

Is it possible to add a credentials file as an asset to the workflow, and make sure that the Gallery server has access to the credentials file?

Workflow

Scheduler

Accepted answers

Thanks for your help, I believe I have solved the issue by adding the credentials to the data connection in the Gallery admin console.

Then adding myself and other users to the data connection.

Now when saving the Workflow on the Designer, I have the option of selecting the Gallery saved connection.

The issue was I had tried adding the connection as a system connection on the Designer server, instead of setting it up on the Gallery server and sharing it from there.

All comments

Hello @ronniet7626 ,

Have you tried to saving the connections into the gallery directly? When you enter as an admin there is on the left a menu called connections where you can set them up either as SQL, Oracle or as a string.

If you save the connection parameters as a string there you should be able to test the connection and after use it for your workflow.

Regards

Thanks for your suggestion.

I have already added the data connection on the admin panel in Gallery.

The issue is that when I run the workflow in Designer I have to enter credentials to connect to the Snowflake server manually.

When I try to schedule the workflow from Gallery which is running on a different host there is no way to pass the credentials needed to access the Snowflake server.

I need some way of getting Gallery to pick up the credentials and use them.

Any other suggestions/help would be much appreciated.

Ronnie

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703