SQL Playground Editor

as a all in one data orchestration platform it is often necessary to run basic queries against certain data connectors to confirm logic and data this can also be used to validate queries you might use in the sql data query docid\ ehlb1msx8m2a96j4ttc1p source connector when trying to sync a single query with a major target destination of your choice sql playground supported connectors currently dlh io only supports a few connectors for your ad hoc queries in the sql playground editor this is done on purpose since your ide or local machine tool typicall has many more features and does the heavy lifting whereas dlh io is meant for basic queries to validate the query can run successfully before and if being used in the sql data query docid\ ehlb1msx8m2a96j4ttc1p connector source connectors netsuite (oracle netsuite) docid\ wygqqfsbdfs8mq7cz6euf (web services not suite analytics) target connectors snowflake docid\ rw9k3kv5z2f7ew97qezsp prerequisites you need to have created a connector for one of the supported connectors overview write basic queries in the supported language of the connector for example any single query that works against snowflake should work in the sql playground editor, and for example any suiteql query that works in netsuite should work here as well navigate to the option transformation > sql playground or from the transformations page click on the open sql playground button on the sql playground page, you have a basic editor sql playgoud editor click the option dropdown box in the upper right of the page to select your supported connection, if already created (see prerequisite) enter a sql statement that you wish to test or get the results from click the run button to execute the query note like most editors, it will run the single query in the editor, but if mulitple queries, it will run the query which the cursor is on highlight text when multiple queries are available in the editor view the results in the query result s section features & shortcuts some basic features and shortcusts are provided to make running queries easier highlight text to query highlight the text you wish to query then either use the run query shortcut or press the run button control/command + enter/return query shortchut to run a query in the editor faq what is the query size limit queries returned limited to 500 rows this is a hard restriction for standard plans and can be increased for business critical plan customers we force a limit or a top logic on queries where possible