You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

DVD Trying to pull all records from Snowflake table

Question
10
Views
0
Comments
edited Sep 11, 2019 5:22AM in Oracle Analytics

Summary

Count query tries to pull all records from the table

Content

Hello,

I am experimenting connecting Data Visualization Desktop Version 12.2.5.3.0-20190529084035 to Snowflake.

I was able to successfully create connection and create a dataset based on a TRIPS table that Snowflake uses for it's hands on demos.

When trying to create a simple visualization, I created a calculated column Count_Rows with the expression Count(BIKEID).

I am expecting a sql similar to : select count(bikeid) from trips to be submitted to Snowflake. 

Instead, I get an error as follows:

Odbc driver returned an error (SQLExecDirectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!