Draxlr Terminology

Explore essential Draxlr terminology.

Saved Query

A Saved Query is an SQL query stored for future use or to view results on a recurring basis. You can assign it a name and description for easy reference.

Uses of a Saved Query

  • Create Dashboard Elements
  • Create Integrations

Viewing Options

A saved query can be displayed as:

  • Table
  • Graph
  • Computed Card (for single-value results, such as orders count)

Query Builder

Query Builder is a no-code tool that allows you to create SQL queries without technical expertise.

Features

  • Filters: Refine data by setting conditions.
  • Sort: Arrange results in ascending or descending order.
  • Join: Combine data from multiple tables.
  • Aggregation
    • Group By: Group records based on specific columns.
    • Functions: Perform calculations like sum, count, or average.
  • Select: Choose specific columns for query output.

Integration

Draxlr offers four types of integrations:

  • Slack: Receive Slack alerts when your data changes.
  • Email: Get email notifications for data updates.
  • API: Create custom API endpoints for any saved query.
  • Google Sheets: Sync saved query data to a Google Sheet.

Dashboards & Dashboard Elements

You can create multiple dashboards, each containing multiple dashboard elements for data visualization like Graph, Table, etc.