website logo
⌘K
Getting Started 🚀
What is DataLakeHouse.io?
Our Business-Value Focus
Learn the Basic Concepts
Connectors
Operations Applications
Asana
Aloha POS
Baremetrics
Beans Route
BILL
Bloom Growth
Bullhorn
Calendly
Ceridian Dayforce
ClinicalTrials.gov
ConnectWise
DBT Cloud
DBT Cloud Log Stream
Facebook Ads
Food Delivery Service Connector
Google Analytics 4
Google Play
Harvest
Hubspot
Jira
MailChimp
McLeod Transportation
Microsoft Teams
NetSuite (Oracle NetSuite)
NetSuite SuiteAnalytics
Optimum HRIS
QuickBooks Online
Salesforce
Salesloft
Shift4 Payments
Shopify
Square
Square Marketplace
Stripe
Toast
TriNet
Verizon Wireless Business
Workday HCM
Xero
Zendesk Sell
Zoom
Databases
Files & Object Storage
SQL Data Query
SSH Tunnel Setup for Hosted Database Systems
SQL Playground Editor
SQL Transformations
DBT Cloud Transformations
Terraform: Reverse Terraforming
Sync Bridge (Data Pipelines)
Create a Sync Bridge
Manually Run a Sync Bridge
Deleting a Sync Bridge
Historical Re-sync
Analytics
Access Analytics
Snowflake Usage Analytics
Data Catalog
Create the Catalog
Populate the Catalog
Access the Catalog
Data Warehouse Clouds
❄️Snowflake
Open Source DW Models
Alerts & Notifications
Slack Notifications
Logs & Monitoring
Security
Callback Links
Service Level Agreement (SLA)
Release Notes
July 2023
June 2023
May 2023
April 2023
Q3 2022
Q4 2022
Community Overview
Contributor Agreements
Code Contribution Guide
About
Customer Support
License
Viewpoint
Credit Consumption Breakdown
Docs powered by
Archbee
website logo

SQL Playground Editor

8min

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.

  • Source Connectors
    • NetSuite (Oracle NetSuite) (Web Services not Suite Analytics)
  • Target Connectors
    • Snowflake

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

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.





Updated 28 Jul 2023
Did this page help you?
PREVIOUS
SSH Tunnel Setup for Hosted Database Systems
NEXT
SQL Transformations
Docs powered by
Archbee
TABLE OF CONTENTS
Supported Connectors
Prerequisites
Overview
Features & Shortcuts
FAQ
What is the Query Size Limit
Docs powered by
Archbee