"Could not create destination table" Error - Snowflake

[kaisarkhatak]

I ran into a "Could not create destination table" Error with DataRobot and Snowflake Integration.

I think there might be a set-up/config issue. I followed the steps in the online documentation, but am wondering if there are permission issues related to the connection account(s).

I was able to connect to Snowflake and create the table with the user account.

I was able to connect to Snowflake via the data connection and return schema-table datasets for predictions using the datarobot model.

The issue is when I try to send the predictions to Snowflake schema in table format. Do I need to create the table first manually in Snowflake?

Snowflake JDBC Driver » 3.12.10

https://community.datarobot.com/t5/resources/getting-started-with-snowflake-datarobot/ta-p/5908

https://community.datarobot.com/t5/resources/datarobot-amp-snowflake-server-side-model-scoring/ta-p/...

https://app2.datarobot.com/docs/load/data-conn.html#dataconn-add

https://app2.datarobot.com/docs/deploy/deploy-pred/integrations.html?highlight=snowflake#microsoft

[kaisarkhatak · Accepted solution]

Solved:

DataRobot was able to write the table when I changed the database name in the JDBC string. It looks like there was a permissions (issue) in Snowflake with the PC_DATAROBOT_ROLE db role and user PC_DATAROBOT_USER. Closing the issue for now.

Before:

jdbc:snowflake://ZRA67922.us-east-1.snowflakecomputing.com/?warehouse=PC_DATAROBOT_WH&db=PC_DATAROBOT

After:

jdbc:snowflake://ZRA67922.us-east-1.snowflakecomputing.com/?warehouse=PC_DATAROBOT_WH&db=CUSTOMERDATA