SummaryQuery

Run Query

Table Name: summary_queries

Columns
Name Type Nullable Primary Key Default
id UUID False Yes CallableColumnDefault(<function uuid4 at 0x74d1ead00fe0>)
name VARCHAR(255) False No None
description VARCHAR(512) True No None
source_table VARCHAR(255) False No None
dimensions JSONB False No None
metrics JSONB False No None
filters JSONB True No None
joins JSONB True No None
derived_fields JSONB True No None
filter_expression TEXT True No None
filter_expression_type VARCHAR(32) True No ScalarElementColumnDefault('jsonlogic')
post_process_expression TEXT True No None
post_process_expression_type VARCHAR(32) True No ScalarElementColumnDefault('jinja')
order_by JSONB True No None
limit INTEGER True No None
tags JSONB True No None
is_public BOOLEAN True No ScalarElementColumnDefault(True)
active BOOLEAN True No ScalarElementColumnDefault(True)
created_at DATETIME False No None
created_by VARCHAR(128) True No None
updated_at DATETIME False No None
Data Filters

Active Filters:

Data Records
id name description source_table dimensions metrics filters joins derived_fields filter_expression filter_expression_type post_process_expression post_process_expression_type order_by limit tags is_public active created_at created_by updated_at
Relationships
Relationship Name Target Model Direction
results summary_results ONETOMANY