SQL Playground Editor

6min

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 source connector when trying to sync a single query with a major target destination of your choice.

SQL Playground
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 connector.

Prerequisites

  1. 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
SQL Playgoud Editor

  1. Click the option dropdown box in the upper right of the page to select your supported connection, if already created (See prerequisite).
  2. Enter a SQL statement that you wish to test or get the results from
  3. 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.
  4. View the results in the Query Results 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

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.





Updated 28 Jul 2023
Doc contributor
Did this page help you?
PREVIOUS
SSH Tunnel Setup for Hosted Database Systems
NEXT
SQL Transformations
Docs powered by Archbee