Add Queries to a Worksheet

Create queries to explore the data from your links using SQL. You can also run your queries to explore your current data.

Before creating a query you must create at least one worksheet. For more information on creating worksheets, see Create Worksheets.

1. On the Worksheets page, select a worksheet from the Worksheets list.
2. If this is the first query in your worksheet, click Create Query, otherwise click Create located below the worksheet description.
3. Enter a name to identify the query.
4. Click Create.
   The new query appears in the list of queries.
5. Enter your Spark SQL query in the Enter query text field located below the query name.
   If when you defined your links you selected Use from Worksheets, you can query the data sources associated with that link. To do this, use the name of your link in the from clause of your query.
   For more information about SQL, see Spark SQL Programming Guide.

Your query is created and the Spark SQL code is automatically saved.

For information on how to run your query, see Run Ad Hoc Queries.

For information on how to reuse a query in a link, see Reuse Your Queries.