Query a Dataset
Updated: February 13, 2014
You can use the Query tab in Marketplace Service Explorer to create a custom query without writing any code. The query results can then be transformed into graphical visualizations, shared with others, and exported to other programs for detailed analysis. This topic walks you through querying your data from within Service Explorer, which is where it all begins.
If you want to query a dataset using code, see the topic Query Marketplace Datasets from your App and its sub-topics.
The following prerequisites must be met before you can query a dataset in Service Explorer:
A valid Windows Live ID or OrgID.
If you need a Live ID go to the Windows Live home page and sign-up for a Live ID.
A valid Marketplace account.
If you do not have a Marketplace account, go to the topic Create Your Marketplace Account and follow the instructions there.
A subscription to a dataset of interest.
If you have not subscribed to a dataset, go to the topic Subscribe to a Data Offer and follow the instructions there.
When you click Explore this Dataset, Service Explorer launches in a separate window or tab with one of these results:
The dataset has no required parameters (it may or may not have optional parameters).
Service Explorer executes a parameterless query and returns the first 100 rows of the dataset.
The dataset has one or more required parameters (it may also have optional parameters).
No query is executed until you,;
Fill in data values for all required parameters, and
Click Run Query.
- Fill in data values for all required parameters, and
Query Result – Table Format
Figure 2 shows a Table view from a query of the Alteryx Census Demographic Data dataset.
Figure 2 – Table of Query Results