Datasets are schema-based, time series-optimized database tables that have auto-generated, permissioned APIs and API docs. You can query and operate on datasets in a codeless fasion in the console or programatically using Apperate’s Get Data method or our open-source client libraries.
Apperate validates incoming data against the dataset’s schema, giving you further confidence in your data. Each property (think database column) has a type, is required (or not), and allows null (or not).
See the Dataset Properties reference for details on property types, constraints, and mappings.
Here we’ll introduce these dataset topics:
Indexing with Unique Index
Normalizing with SmartLinks
Permisioning with Tokens
Indexing with Unique Index#
Each dataset has a Unique Index composed of a primary index, secondary index (optional), and date index. This index determines how the dataset records are identified, deduplicated, partitioned, and stored.
Unique Index = primary + secondary + date
primary and secondary (optional) indexes: Set these to any property. Indexes should ideally be assigned to properties that signify an important identifier and/or category for the dataset.
date index: Set this to any date property or leave it unset to use record creation timestamps. The property mapped to the date index is the primary mechanism by which data is time-sorted.
Querying on Key, Subkey, and Date#
The Data API leverages the Unique Index components. It nicknames them as follows …
Key (primary index)
Subkey (secondary index)
Date (date index)
Here’s an example of mapping for a company news dataset.
A stock symbol
The record’s date/time
Here’s a URL format that queries on all three components:
Since your base URL, dataset, and workspace are already known, you can concentrate on plugging key (
AAPL), subkey (
CNN), and date (
2019-02-20) values into your
GET /data requests.
Here are some example queries.
Get the AAPL news record from CNN on 2019-02-20:
Get all AAPL news records from any source on 2019-02-20:
Get all AAPL news records from CNN:
Get all AAPL news records from any source:
Permissioning with Tokens#
Your datasets are private by default. You can share a dataset’s API with other parties by giving them a public API token that has access to the dataset.
Access and Security shows you how to create API tokens with fine-grained permissions.
Now you know the fundamentals of Apperate dataset schemas, you know how to permission with tokens, and are familiar with normalizing financial symbols with SmartLinks.
Data Model Examples demonstrates using dataset schemas and the Unique Index to represent various data models.
Updating Dataset Schemas shows you how to update dataset schemas and explains how updates work.
Search Data: These articles show how to query data.