Error creating table "table": Cannot perform CREATE TABLE.

[Basheer]

Hi Team,

I going load data from SAP table to snowflake. am getting below error and also i have checked in snowflake db table was creating, But through Alteryx through error.

Can any one help out on this.

Error :

Output Data (2) Error creating table "table": Cannot perform CREATE TABLE. This session does not have a current database. Call 'USE DATABASE', or use a qualified name.¶CREATE TABLE "table" ("LOG_TIME" datetime,"LOG_LEVEL" varchar(10),"LOG_MESSAGE" varchar(16777216),"SYS_PK" NUMBER(35, 0))

[TheOC]

hi @Basheer 

Does your user account have privileges on that database and subsequent objects.?

Using here as reference:
https://community.snowflake.com/s/question/0D50Z00008Uvt1wSAB/select-statement-issue

You may just need to change a couple permissions to allow yourself access through the Alteryx Tool

Hope this helps!
TheOC

[Basheer]

@TheOC 

thanks for answer,

I am able to create tables in snowflake DB, but DB schema am calling in Alteryx side thronging an above error,

[TheOC]

hi @Basheer 

You may have to try the following, at the start of your SQL:

https://docs.snowflake.com/en/sql-reference/sql/use-database.html

[danilang]

Hi @Basheer 

From your error message.  This session does not have a current database. Call 'USE DATABASE', or use a qualified name 

Modify your query to use the fully qualified name <database_name>.<schema_name>.<object_name>.  

Dan

[Ab3111]

Hi @danilag,

I am getting the same error. Were you able to find a solution to this?

Ankur

[flordels]

I am seeing folks write about this error or type of error quite frequently. It has to do with the connection being used. In my case that is odbc but there will be analogous configuration properties.

When creating the odbc connection to be used within alteryx it is critically important to point to the database when configuring the default database property. 

in a given workflow in order to connect to two different databases but same instance of sql server I need two odbc connections with each connection specifying the databse I want to connect to. Make sense?