GraphQL Data APIs: Support for rollups by Week

Data API

When querying time series datasets, you can now easily group data by week. A new derived field <columnName>WeekDate will return the first day of the week the time value falls within. With an ISO-standard default of MONDAY, the firstDayOfWeek is configurable with an options configuration parameter.

query {
  <tableName>Query(
    groupBy: [eventCreatedTimeWeekDate]
    orderBy: {eventCreatedTimeWeekDate:desc}
    options: {firstDayOfWeek: SUNDAY}
  ) {
    eventCount
    eventCreatedTimeWeekDate
  }
}
Patch logo
Cover

Patch Changelog

Jul

12

Python Data Packages

Announcement

Data Packages are code libraries with a live connection to an underlying data source. They provide a powerful interface for querying, access control, versioning, performance optimization and more; over all your data, no matter where it lives. This could be any database or file system.

The Data Package can be installed using a package manager like pip . Then, it's imported like a library dependency into your code, whether that’s a backend service performing machine learning or enrichment tasks, a customer-facing application, or even an external consumer buying access from you directly to build using the package.

A dpm-agent intelligently routes queries submitted by consumers of a Data Package to the appropriate backend source, enforces access policies and applies performance optimizations. 

Today, we're excited to announce support for generated Python packages!

Sign up for early access at www.dpm.sh!

Jul

05

TypeScript / Node.js Data Packages

Announcement

Data Packages are code libraries with a live connection to an underlying data source. They provide a powerful interface for querying, access control, versioning, performance optimization and more; over all your data, no matter where it lives. This could be any database or file system.

The Data Package is imported like a library dependency into your code, whether that’s a backend service performing machine learning or enrichment tasks, a customer-facing application, or even an external consumer buying access from you directly to build using the package.

A dpm-agent intelligently routes queries submitted by consumers of a Data Package to the appropriate backend source, enforces access policies and applies performance optimizations. 

Today, we're excited to announce support for generated Node.js & TypeScript packages!