Release Overview

Aunalytics is excited to announce the February 2021 Daybreak release to our clients. This release will provide clients with model and site enhancement information along with any fixes to existing functionality we have included.

Daybreak

Query Wizard: New “In the Range of” Operator

The Query Wizard in the Daybreak Data Builder now supports a new operator for dates: “In the range of.” This operator serves as a placeholder for relative dates calculated from the present date when the query is executed, allowing query creators to define a range of relative dates. For example, a query could search for accounts created in the week immediately preceding when the query is run:

first in the range of screenshot

The Query Wizard interface provides a number of predefined date ranges:

  • Past ranges:
    • Yesterday
    • Last week/month/quarter/year
    • The last seven/thirty days
  • Present ranges:
    • Today
    • This week/month/quarter/year
  • Future ranges:
    • Tomorrow
    • Next week/the next two weeks/next month/next quarter

In addition to the predefined ranges, users can select “special” from the drop-down menu and define their own ranges using three criteria. Possible special ranges include examples such as the first quarter of last year or the week five weeks into the future.

second in the range of screenshot

SQL Builder: Autocomplete functionality

The SQL Builder mode of Data Builder now has an autocomplete feature alongside syntax highlighting for assistance in writing SQL query code. The autocomplete feature presents a popup menu with suggestions matching the characters the user has typed. Suggestions are drawn from SQL reserved words (e.g. “SELECT”, “AVG”, or “JOIN”) as well the field names for the Daybreak datamart being queried. So for example, typing “Date” will bring up a list of suggestions beginning with the “DATE” keyword in SQL as well as the datamart field names “DateJoined” and “DateofBirth” from the Daybreak Customer Table. This feature makes writing SQL queries against the Daybreak datamarts much easier since users not need to rely as much on the datamart field names browser in the SQL editor’s schema panel.

sql editor syntax highlight example

Data Builder: Streamlined Interface Buttons

The Daybreak Data Builder app is undergoing minor interface changes.

The “New Query” button previously displayed a dropdown menu from which the user could choose the desired query type: Query Wizard or SQL Editor. This drop-down has been replaced by a set of icons for Query Wizard, and SQL editor. Clicking each icon will create a new query in that mode.

streamlined interface buttons

Similarly, the action button to close the current query has been renamed from “Cancel” to “Back.” Users will still be prompted to save any modifications before the current query is closed.

databuilder action buttons

Aunsight™ Golden Record

Transactional Workflows

Aunsight Golden Record now allows users to configure a Transactional Workflow that can move larger datasets from a source database to the datastore of their choice while bypassing the Mapping, Matching, and Merging configuration steps. This new type of workflow supports bulk data transfers to provide fast, cloud-native data transfer from client data sources into both Amazon S3 and the Aunsight platform.