DVD Trying to pull all records from Snowflake table
Summary
Count query tries to pull all records from the tableContent
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:
0