Querying

Catalog

Discover and navigate the collections and views that are available in Rich Data Services.

• Listing Collections
• Listing Data Sources
• View Data Source

Data

Rich Data Services offers SQL like functionality to query and tabulate data, combined with metadata search and retrieval. Selecting data can be done with traditional parameters but also includes innovative features such as the ability to use regular expressions or keywords/concepts to select variables, the option of performing on the fly recodes or computing new values, and paging to control the data flow. RDS also exposes a tabulate operation, which provides specialized parameters to easily and rapidly produce aggregated data or tables.

• Select
• Rich Queries
• Including Metadata
• Filtering Results
• Ordering Results
• Paginating Results
• Computing Variables
• Recoding Variables
• Tabulations
• Dynamic Serialization
• Saving a Query in Session

Metadata

Rich Data Services has the ability to capture extensive knowledge around the data, such as provenance, extended column/variable information (e.g. plain labels, definitions, questions, concepts), classifications (code/value labels), and other custom properties. This metadata is an essential part to the application and improve the querying, formatting, and packaging services of RDS. The metadata can be injected and returned alongside the data in JSON, or directly queried using dedicated metadata services. This section will cover the ability to query the metadata by itself. 

• Classifications
• Variables