From the GraphiQL interface of the data portal, users can use the Graph Model or Flat Model which match to Postgres and ElasticSearch databases, respectively. The same queries can be sent to both the flat and graph model API endpoints from the command-line.
In the Flat Model, our microservice Guppy converts GraphiQL queries and hits the Elasticsearch database. Here, queries support Aggregations for string (bin counts; number of records that each key has) and numeric (summary statistics such as minimum, maximum, sum, etc) fields. For more details see the full description on our Guppy repository on Github or on the User Guide.
In the Graph Model, our microservice Peregrine converts GraphiQL queries and hits the PostgreSQL database. For more information see the full description on our Peregrine repository on Github or on the User Guide.