Looking for Dashboard < 0.12.0, or the Query Engine < v0.10.0?
AppAppDocumentationDocumentationBlogBlog
  • Get started
  • Welcome
  • How does Vizzly work?
  • Standard or custom reporting
    • Local Query Engine & React
      • Introduction
      • Building a config programmatically
      • Identifying users
      • Deployment
    • Programmatic dashboards
      • Introduction
      • Postgres setup
      • NodeJS Identity
      • React frontend
  • Managing environments
  • Frontend
  • Dashboard
    • Properties
      • Core
      • identity
      • queryEngineEndpoint
      • dataSets
      • data
      • runQueries
      • queryEngineConfig
      • Multiple dashboards
      • dashboardId
      • parentDashboardId
      • Customization
      • theme
        • accordion
        • alerts
        • baseFont
        • buttons
        • charts
        • chips
        • cellLimit
        • dashboard
        • detail
        • dropdowns
        • editor
        • filters
        • forms
        • header
        • icons
        • library
        • lists
        • modals
        • panels
        • popoverMenu
        • radioGroup
        • rowLimit
        • search
        • section
        • tables
        • tabs
        • titles
        • tooltips
        • version
        • Examples
      • customViews
      • dataPanel
      • datePickerFormat
      • defaultFormats
      • dateTimeFormatOptions
      • numberFormatOptions
      • developerTools
      • excludeComponents
      • featureToggles
      • formatPanel
      • Icons
      • includeComponents
      • labelFormat
      • maxCSVDownloadLimit
      • nullValueAlias
      • organizationName
      • textOverrides
      • timeZone
      • valueAlias
      • Component Overrides
      • Event handlers
      • onEditorUpdate
      • onDashboardLoad
      • onViewClick
      • renderTableCell
      • onDashboardFilterChange
      • trackEvent
      • Filters
      • dateFilterOptions
      • dashboardFilters
      • cascadeFilterSelection
      • filterLibrary
      • Programmatic
      • parentDashboard
      • variables
      • Scheduled Reporting
      • reportScheduleOptions
    • Theme and experience
    • Log level
    • CSS
    • React
    • Quick Installation
    • Web component
    • Vue
    • HTML
    • Svelte
    • Angular
    • State Management
    • Setup
    • Filters
    • Controls
  • Editor
    • Properties
      • Core
      • view
    • Theme and experience
    • React
    • Quick Installation
    • Web component
    • HTML
  • Services
    • Setup
    • Initializing
    • Building dashboards
    • Examples
      • Dashboard
      • Views
        • Area Chart
        • Column chart
        • Bubble Chart
        • Bubble Chart
        • Line Chart
        • Pie Chart
        • Sunburst Chart
        • Scatter Chart
        • Combo Chart
        • Pivot table
        • Basic Table
        • Single stat
        • Progress
        • Mercator Map
        • Horizontal bar chart
      • Cell
      • Header
      • Library
      • Row
    • Dashboard CRUD
    • Create
    • Read
    • Update
    • Delete
    • Querying Data
    • Query
    • Scheduled reporting
    • Create
    • Read
    • Delete
  • Query Engine
  • In-browser
    • Vizzly Query Engine
      • Integrations
      • Environment variables
        • Local
        • Amazon Web Services
          • AWS App Runner
            • Adding secrets
            • IAM role
            • App runner service
        • Google Cloud Platform
          • GCP Cloud Run
        • Microsoft Azure
          • 1. Initial setup
          • 2. Create secrets
          • 3. Add secrets
        • Heroku
      • Config storage
        • Vizzly API
        • GitHub
        • AWS S3
        • Remote Config
      • Access
      • Performance
      • Query engines and projects
      • Build using SQL
      • SQL Data Sets
      • SQL Fields
      • SQL Views
        • YoY Example
      • Advanced
      • Time zones
      • Config schema
        • BigQuery
        • MariaDb
        • MySQL
        • Postgres
        • Redshift
        • Snowflake
        • SQL Server
      • Permanent data set filters
        • Headers
        • Create Results
      • GitHub Actions CI
      • SSL termination
      • Smart Proxy
        • Architecture
        • Implementation
    • Custom
      • Query
      • Result
  • Cloud
  • Which Query Engine?
  • Backend
  • Identity and Multi-Tenancy
    • Quick start
    • Node client
    • Python client
    • Ruby guide
    • Self sign
    • Property explanations
      • Project ID
      • User Reference
      • Secure Filters
      • Scope
      • Data Sets
      • Advanced
      • Access type
      • Parent Dashboard IDs
      • Database Schema Access
      • Parameters
    • Load your private key from an environment variable
    • Key Pair
  • Sharing
  • Webhooks
    • Get started
    • Scheduled reports
  • PDF Reporting
  • Support
  • CLI
  • Slack
    • Parent & child dashboards
    • Data set
    • Field
    • Verified views
    • Advanced
    • Time format
    • Data type
    • View attributes
    • Query
    • Result
  • License
      • 0.14.4
      • 0.14.3
      • 0.14.2
      • 0.14.1
      • 0.14.0
      • 0.12.15
      • 0.12.14
      • 0.12.13
      • 0.12.12
      • 0.12.11
      • 0.12.9
      • 0.12.8
      • 0.12.7
      • 0.12.5
      • 0.12.2
      • 0.12.1
      • 0.12.0
      • 0.11.0
      • 0.10.0
      • 0.9.1
      • 0.9.0
      • 0.8.2
      • 0.8.1
      • 0.8.0
      • 0.7.4
      • 0.7.3
      • 0.7.2
      • 0.7.1
      • 0.7.0
      • 0.6.4
      • 0.6.0
      • 0.5.0
      • 0.4.19
      • 0.4.18
      • 0.4.16
      • 0.4.13
      • 0.4.11
      • 0.4.9
      • 0.4.8
      • 0.4.7
      • 0.4.5
      • 0.4.4
      • 0.4.3
      • 0.4.0
      • 0.3.33
      • 0.3.31
      • 0.3.30
      • 0.3.29
      • 0.3.27
      • 0.3.25
      • 0.3.22
      • 0.3.21
      • 0.6.1
      • v0.11.12
      • v0.11.11
      • v0.11.8
      • v0.11.7
      • v0.11.5
      • v0.11.4
      • v0.11.3
      • v0.11.2
      • v0.11.1
      • v0.11.0
      • v0.9.0
      • v0.8.0
      • v0.7.0
      • v0.6.5
      • v0.6.4
      • v0.6.2
      • v0.6.1
      • v0.6.0
      • v0.5.3
      • v0.5.2
      • V0.6.6
      • V0.6.7
      • V0.6.8
      • V0.6.9
      • 0.4.12
      • 0.4.10
      • 0.4.0
      • 0.3.0
      • 0.2.7
      • 0.2.4
      • 0.2.3
      • 0.2.2
      • 0.2.0
      • 0.1.11
      • 0.2.8
      • 0.2.4
      • 0.1.5
      • 0.1.4
      • 0.1.13
      • 0.1.6
    • Support Request Guidance
    • Vizzly Query Engine
  • App
  • Documentation
  • Blog
  • Get started
  • Welcome
  • How does Vizzly work?
  • Standard or custom reporting
    • Local Query Engine & React
      • Introduction
      • Building a config programmatically
      • Identifying users
      • Deployment
    • Programmatic dashboards
      • Introduction
      • Postgres setup
      • NodeJS Identity
      • React frontend
  • Managing environments
  • Frontend
  • Dashboard
    • Properties
      • Core
      • identity
      • queryEngineEndpoint
      • dataSets
      • data
      • runQueries
      • queryEngineConfig
      • Multiple dashboards
      • dashboardId
      • parentDashboardId
      • Customization
      • theme
        • accordion
        • alerts
        • baseFont
        • buttons
        • charts
        • chips
        • cellLimit
        • dashboard
        • detail
        • dropdowns
        • editor
        • filters
        • forms
        • header
        • icons
        • library
        • lists
        • modals
        • panels
        • popoverMenu
        • radioGroup
        • rowLimit
        • search
        • section
        • tables
        • tabs
        • titles
        • tooltips
        • version
        • Examples
      • customViews
      • dataPanel
      • datePickerFormat
      • defaultFormats
      • dateTimeFormatOptions
      • numberFormatOptions
      • developerTools
      • excludeComponents
      • featureToggles
      • formatPanel
      • Icons
      • includeComponents
      • labelFormat
      • maxCSVDownloadLimit
      • nullValueAlias
      • organizationName
      • textOverrides
      • timeZone
      • valueAlias
      • Component Overrides
      • Event handlers
      • onEditorUpdate
      • onDashboardLoad
      • onViewClick
      • renderTableCell
      • onDashboardFilterChange
      • trackEvent
      • Filters
      • dateFilterOptions
      • dashboardFilters
      • cascadeFilterSelection
      • filterLibrary
      • Programmatic
      • parentDashboard
      • variables
      • Scheduled Reporting
      • reportScheduleOptions
    • Theme and experience
    • Log level
    • CSS
    • React
    • Quick Installation
    • Web component
    • Vue
    • HTML
    • Svelte
    • Angular
    • State Management
    • Setup
    • Filters
    • Controls
  • Editor
    • Properties
      • Core
      • view
    • Theme and experience
    • React
    • Quick Installation
    • Web component
    • HTML
  • Services
    • Setup
    • Initializing
    • Building dashboards
    • Examples
      • Dashboard
      • Views
        • Area Chart
        • Column chart
        • Bubble Chart
        • Bubble Chart
        • Line Chart
        • Pie Chart
        • Sunburst Chart
        • Scatter Chart
        • Combo Chart
        • Pivot table
        • Basic Table
        • Single stat
        • Progress
        • Mercator Map
        • Horizontal bar chart
      • Cell
      • Header
      • Library
      • Row
    • Dashboard CRUD
    • Create
    • Read
    • Update
    • Delete
    • Querying Data
    • Query
    • Scheduled reporting
    • Create
    • Read
    • Delete
  • Query Engine
  • In-browser
    • Vizzly Query Engine
      • Integrations
      • Environment variables
        • Local
        • Amazon Web Services
          • AWS App Runner
            • Adding secrets
            • IAM role
            • App runner service
        • Google Cloud Platform
          • GCP Cloud Run
        • Microsoft Azure
          • 1. Initial setup
          • 2. Create secrets
          • 3. Add secrets
        • Heroku
      • Config storage
        • Vizzly API
        • GitHub
        • AWS S3
        • Remote Config
      • Access
      • Performance
      • Query engines and projects
      • Build using SQL
      • SQL Data Sets
      • SQL Fields
      • SQL Views
        • YoY Example
      • Advanced
      • Time zones
      • Config schema
        • BigQuery
        • MariaDb
        • MySQL
        • Postgres
        • Redshift
        • Snowflake
        • SQL Server
      • Permanent data set filters
        • Headers
        • Create Results
      • GitHub Actions CI
      • SSL termination
      • Smart Proxy
        • Architecture
        • Implementation
    • Custom
      • Query
      • Result
  • Cloud
  • Which Query Engine?
  • Backend
  • Identity and Multi-Tenancy
    • Quick start
    • Node client
    • Python client
    • Ruby guide
    • Self sign
    • Property explanations
      • Project ID
      • User Reference
      • Secure Filters
      • Scope
      • Data Sets
      • Advanced
      • Access type
      • Parent Dashboard IDs
      • Database Schema Access
      • Parameters
    • Load your private key from an environment variable
    • Key Pair
  • Sharing
  • Webhooks
    • Get started
    • Scheduled reports
  • PDF Reporting
  • Support
  • CLI
  • Slack
    • Parent & child dashboards
    • Data set
    • Field
    • Verified views
    • Advanced
    • Time format
    • Data type
    • View attributes
    • Query
    • Result
  • License
      • 0.14.4
      • 0.14.3
      • 0.14.2
      • 0.14.1
      • 0.14.0
      • 0.12.15
      • 0.12.14
      • 0.12.13
      • 0.12.12
      • 0.12.11
      • 0.12.9
      • 0.12.8
      • 0.12.7
      • 0.12.5
      • 0.12.2
      • 0.12.1
      • 0.12.0
      • 0.11.0
      • 0.10.0
      • 0.9.1
      • 0.9.0
      • 0.8.2
      • 0.8.1
      • 0.8.0
      • 0.7.4
      • 0.7.3
      • 0.7.2
      • 0.7.1
      • 0.7.0
      • 0.6.4
      • 0.6.0
      • 0.5.0
      • 0.4.19
      • 0.4.18
      • 0.4.16
      • 0.4.13
      • 0.4.11
      • 0.4.9
      • 0.4.8
      • 0.4.7
      • 0.4.5
      • 0.4.4
      • 0.4.3
      • 0.4.0
      • 0.3.33
      • 0.3.31
      • 0.3.30
      • 0.3.29
      • 0.3.27
      • 0.3.25
      • 0.3.22
      • 0.3.21
      • 0.6.1
      • v0.11.12
      • v0.11.11
      • v0.11.8
      • v0.11.7
      • v0.11.5
      • v0.11.4
      • v0.11.3
      • v0.11.2
      • v0.11.1
      • v0.11.0
      • v0.9.0
      • v0.8.0
      • v0.7.0
      • v0.6.5
      • v0.6.4
      • v0.6.2
      • v0.6.1
      • v0.6.0
      • v0.5.3
      • v0.5.2
      • V0.6.6
      • V0.6.7
      • V0.6.8
      • V0.6.9
      • 0.4.12
      • 0.4.10
      • 0.4.0
      • 0.3.0
      • 0.2.7
      • 0.2.4
      • 0.2.3
      • 0.2.2
      • 0.2.0
      • 0.1.11
      • 0.2.8
      • 0.2.4
      • 0.1.5
      • 0.1.4
      • 0.1.13
      • 0.1.6
    • Support Request Guidance
    • Vizzly Query Engine
Concepts
Query

Query schema

View attributesResult