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

Question

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))

flordels · Answer

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?

Ab3111 · Answer

Hi @danilag,

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

Ankur

danilang · Answer

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 ... Dan