I've been using DataGrip to build queries for NetSuiteĀ (using SuiteAnalytics Connect) and after switching to the
NetSuite2.com data source I noticed something quirky. Essentially, all of my tables and columns need to be wrapped in quotes...if I want to resolve the SQL and use code completion (table/column lookup).
For example, when I run the two queries below they both execute. If I want to use my suiteQL statement elsewhere (script/postman/etc) I have to remove the quotes before the query will work outside of DataGrip. I would love to leverage the code completion on the
NetSuite2.com datasource directly in DataGrip without needing these quotes.
Any suggestions or resources welcome.