Frequently Asked Questions
Queries
Section titled “Queries”Can I write multi-level joins in NimbusQL? Yes. NimbusQL fully supports multi-level joins and combining multiple datasets within the same query.
Is there a row limit on query results? The Free version is limited to 100 query results. The Full version supports unlimited query results with no row limits.
Can I save my queries for future use? Yes. You can save queries with a name and description, then load them back at any time. The Free version supports up to 3 saved queries. The Full version supports unlimited saved queries.
Does NimbusQL support autocomplete? Yes. Press Ctrl + Space to activate autocomplete for table names, field names, and SuiteQL keywords.
Can I run only part of my query? Yes (v2.0+). Highlight a portion of your query text and execute only the highlighted section.
Where is Query History stored? Query History is stored in your current browser only and is not synced across devices. NimbusQL keeps up to 50 of your most recent successful runs. Failed or stopped executes are not recorded. See Query History.
What are Snippets? Snippets are reusable pieces of SuiteQL you can insert into the editor. They are stored in NetSuite, so they persist across browsers and are available to other users. You can only edit or delete snippets you created. See Snippets.
What is Schema Explorer? Schema Explorer is a panel on Write Query for browsing NetSuite records, fields, and joins. Click a name to insert it into the editor. Click Schema to open it. See Schema Explorer.
Scheduled Emails
Section titled “Scheduled Emails”Who can I send scheduled emails to? You can send scheduled emails to any NetSuite employee or any external email address.
What cadences are available for scheduled emails? Daily, weekly, and monthly scheduling cadences are available.
Is there a limit on scheduled emails? The Free version has limited scheduled email functionality. The Full version supports unlimited scheduled emails.
Can I schedule emails from a NetSuite Analytics Dataset? Yes (v1.8+). You can load an existing NetSuite Analytics Dataset as the data source for a scheduled email.
Datasets
Section titled “Datasets”What is the Load Dataset feature? Load Dataset (v1.8+) allows you to use an existing NetSuite Analytics Dataset as the data source for a query or scheduled email, without writing a SuiteQL query manually.
Do I need NimbusQL installed to use NimbusDash? No. NimbusDash works with NetSuite Saved Searches without NimbusQL. However, installing NimbusQL unlocks the ability to use SuiteQL queries as data sources in NimbusDash.
Troubleshooting
Section titled “Troubleshooting”NimbusQL is not appearing in my NetSuite menu after installation. Check that the bundle installation completed successfully in Customization > SuiteBundler > Installed Bundles. If it appears there, try clearing your browser cache and refreshing NetSuite.
I’m getting a query error when executing my query. Check your SuiteQL syntax carefully. Common issues include missing JOIN conditions, incorrect field names, or unsupported SuiteQL functions. Use the autocomplete feature (Ctrl + Space) to verify field and table names.
My scheduled email is not sending. Verify that the schedule is active in the Schedule screen. Check that the recipient email addresses are correct. If sending to external addresses, confirm your NetSuite environment allows outbound emails to external recipients.
My export is taking a long time. Large exports are queued and processed in the background. Check the export queue for the status of your export. Very large result sets may take several minutes to process.
Who can change NimbusQL Settings? Settings is available to NetSuite Administrators and other users with full NimbusQL access. The two options — query method and schema cache lifetime — apply to everyone in the account. See Settings.