CODEWITHSUNDEEP
pythonsqljupyter-notebooksnowflake-cloud-data-platform
jnord
jnord

Reputation: 93

Pulling Snowflake table into Dataframe

I continue to get and error "ProgrammingError: 002003 (42502): SQL compilation error: Object 'Table' does not exist or not authorized. I am using the following code:

con = snowflake.connector.connect(
user = "user.name",
authenticator="externalbrowser",
warehouse = "ware house name",
database = "db name",
schema = "schema name"
)
cur.con.cursor()
sql = "select * from Table"
cur.execute(sql)
df = cur.fetch_pandas_all()

When I execute the code in Jupyter Notebook the browser window opens and authenticates my creds but when it gets to the sql execute line the error rises and tells me that the table does not exist. When I open up Snowflake in my browser I can see that the table does exist in the correct warehouse, database and schema I have in my code.

Has anyone else ever experienced this? Do I need to authorize my user to be able to access this table via Python and Jupyter Notebook?

Upvotes: 2

Views: 1036

Answers (1)

Rich Murnane
Rich Murnane

Reputation: 2940

It's likely your session doesn't have a role assigned to it (current role). You can add the role in your list of connection session paramters, e.g. add something like the following

role = 'RICH_ROLE',

You might want to consider setting a default role for your user.

ALTER USER userNameHere SET DEFAULT_ROLE = 'THE_BEST_ROLE';

docs link: https://docs.snowflake.com/en/sql-reference/sql/alter-user.html

Also, when all else fails, use the fully qualified table name, note this won't help much if the role isn't set:

sql = "select * from databaseName.schemaName.TableName"

Upvotes: 6

Related Questions