I've been using DataGrip to build queries for NetS...
# suiteql
j
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.
c
What dialect do you have configured for the data source?
j
Oracle