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

Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!

DVD Trying to pull all records from Snowflake table

Question
11
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!