Data Stream In Option not working for Snowflake Temporary Tables

[NamrataDhiwar]

I am unable to create temporary table using Data Stream In Option. It generate the Table name dynamically.

But unable to pick the schema.

Error: Unable to Create a table. This session does not have current schema

[Felipe_Ribeir0]

Hi @NamrataDhiwar 

For me, it seems like you need to check the driver/connection string configured for snowflake. Here i do create temporary tables at snowflake, my configuration is like this:

1)The proper snowflake driver is installed

2)The configuration of the snowflake configuration dialog was made with all the parameters, LIKE THE SCHEMA:

3)The connection string that is configured for read/write inside Alteryx Manage In-DB Connections.I use the Write = 'Same as read'.

Connection String: odbc:DSN=xxxx;DATABASE=xxxxx;UID=xxxx;PWD=__EncPwd1__

[apathetichell · Accepted solution]

Add database and schema in your ODBC 64 connection. Just tested - it worked after.

@Felipe_Ribeir0- if you are authenticating via externalbrowser - you can drop your password from the ODBC64 config.

[NamrataDhiwar · Accepted solution]

Thanks It is working

[mkosmicki1]

Clarifying....If I set the schema in the ODBC Manager....I will then need to create an ODBC connection for each data set?

[apathetichell]

@mkosmicki1 for each schema or each table/view? in Snowflake we look at objects as database.schema.table/view - if you do not want to set your odbc at the schema level - don't. If you do not want to set your odbc at the db level - don't. If you do not set db and schema though you will not be able to pick a specific db/schema to write a TEMPORARY TABLE to. You can of course write a permanent table to a db/schema of your choosing.

[mkosmicki1]

@apathetichell Thank you. I still have a lot to learn about Snowflake as a new user. What I've done with it so far has been working well. Although I am a bit anxiety ridden about doing something that causes data chaos. 😁