Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 20 Oracle Analytics Lounge
- 247 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 91 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
OAC generates invalid ROWNUM clause against Snowflake when using RPD subject area
When running an analysis built on an RPD-based Data Model that connects to Snowflake, OAC incorrectly injects an Oracle-specific WHERE rownum <= 500001 clause into the generated SQL.Snowflake does not support ROWNUM → query fails immediately with:
SQL compilation error: error line X at position Y invalid identifier 'ROWNUM'
Example of the failing generated SQL:
SELECT ...FROM ...WHERE ... AND rownum <= 500001 -- ← This causes the error in Snowflake
Expected Behavior: OAC should generate Snowflake-compatible row-limiting syntax when the database type is Snowflake, for example:
FETCH FIRST 500001 ROWS ONLY
OR
LIMIT 500001
Any tips, known workarounds, or patches would be greatly appreciated to fix this error!
Best Answer
-
Resolved by deleting existing connection pool and creating a new one as Snowflake DB.
4
Answers
-
Hi @Dennis Paredes ,
This may be difficult to resolve on a forum. Additional details of the RPD configuration, and review of the logs may be required.
A general question, if you create a connection in /dv against the same schema, then create a workbook against a dataset or a local subject area, does the same issue occur?1 -
Glad you resolved it.
0
