CODEWITHSUNDEEP
snowflake-cloud-data-platform
user12993686
user12993686

Reputation:

Can't create Snowflake temporary stage with Apache Spark connector

We have a scheduled script to fix/restore/update access privileges in Snowflake using GRANT and REVOKE SQL statements. We are using a revoke all, then grant some fashion.

Everything works fine when disconnecting/reconnecting to the Web UI, but some jobs using either ODBC or JDBC seem to be in a stale state.

Should we close all sessions or wait for them to finish? Or is there anything else we can do?

Thanks, Chris

Upvotes: 1

Views: 1226

Answers (1)

user12993686
user12993686

Reputation:

CREATE STAGE access privilege on schema is required by the Apache Spark connector to create temporary stages.

Upvotes: 1

Related Questions