Qodex.ai

Stargate: Leveraging Stargate Document API as a TimeSeries DB

Number of APIs: 2

Showcase querying capabilities of the Stargate Document API via a set of TimeSeries queries mentioned in the blog https://medium.com/building-the-open-data-stack/leveraging-the-stargate-document-api-for-time-series-data-in-cassandra-870b732c1bcd

  1. Report 1: Weekly temperature report by day for a Boston for Week 26 GET {{base_url}}/api/rest/v2/namespaces/{{namespace}}/collections/weatherapi/Boston_26

  2. Report 2: Weekly temperature comparison for 2 Boston & Seattle for Week 26 GET {{base_url}}/api/rest/v2/namespaces/{{namespace}}/collections/weatherapi?where={"week":{"$eq":"26"},"city":{"$in":["Boston","Seattle"]}}&fields=["forecast..date","forecast..stats.day.maxtemp_f","forecast.*.stats.day.mintemp_f"]&page-size=5