Executing SQL Queries
You can open a SQL shell in your cluster and submit SQL queries directly from a web browser.
Before you can start querying data, you must do the following:
-
If your data is in an existing map on the cluster, create a mapping to it first. To do this, either execute a
CREATE MAPPING
statement, or use the connector wizard. -
If your data is in an external system, you can create a data connection to it. To do this, either execute a
CREATE DATA CONNECTION
statement, or use the connector wizard.
Executing Your First Query
To submit a SQL query:
-
Sign into the Cloud console and select your cluster.
-
Go to SQL.
-
Click Compose New Query.
-
Enter your SQL query and execute it.
Your query syntax is saved, and any data resources accessed via mappings or data connections are added to the Data Explorer for future use.