AppAppDocumentationDocumentationBlogBlog
  • Get started
  • Welcome
  • How does Vizzly work?
  • Standard or custom reporting
    • Local Query Engine & React
      • Introduction
      • Building dynamic data sets
      • Identifying users
      • Deployment
    • Programmatic dashboards
      • Introduction
      • Postgres setup
      • NodeJS Identity
      • React frontend
  • Frontend
  • Dashboard
    • Properties
      • Core
      • identity
      • queryEngineEndpoint
      • dataSets
      • data
      • runQueries
      • queryEngineConfig
      • Multiple dashboards
      • dashboardId
      • parentDashboardId
      • Customization
      • theme
        • Accordion
        • Buttons
        • Charts
        • Dashboard
        • Dropdowns
        • Forms
        • Headers
        • Library
        • Modals
        • Notifications
        • Lists
        • Panels
        • Tables
        • Tabs
        • Live Examples
      • featureToggles
      • textOverrides
      • Icons
      • Component overrides
      • labelFormat
      • dataPanel
      • formatPanel
      • excludeComponents
      • includeComponents
      • maxCSVDownloadLimit
      • numberFormatOptions
      • dateTimeFormatOptions
      • organizationName
      • developerTools
      • Event handlers
      • onEditorUpdate
      • onDashboardLoad
      • onViewClick
      • onDashboardFilterChange
      • trackEvent
      • Filters
      • dateFilterOptions
      • dashboardFilters
      • cascadeFilterSelection
      • Programmatic
      • parentDashboard
      • Scheduled Reporting
      • reportScheduleOptions
    • Theme and experience
    • Management
    • Log level
    • CSS
    • React
    • Quick Installation
    • Web component
    • Vue
    • HTML
    • Svelte
    • Angular
    • State Management
    • Setup
    • Filters
    • Controls
  • Services
    • Setup
    • Initializing
    • Building blocks
    • Views
      • Area Chart
      • Column chart
      • Line Chart
      • Pie Chart
      • Scatter Chart
      • Combo Chart
      • Pivot table
      • Basic Table
      • Single stat
      • Progress
      • Mercator Map
      • Horizontal bar chart
    • Cell
    • Header
    • Library
    • Row
    • Dashboard
    • Dashboard Manager
    • Initializing
    • Creating
    • Updating
    • Deleting
    • Fetching
  • Query Engine
  • In-browser
      • Integrations
      • Environment variables
      • Normalized
        • Building data sets
        • Config storage
          • Vizzly API
          • GitHub
          • AWS S3
      • Dynamic
        • Config
          • Schema
            • BigQuery
            • MariaDb
            • MySQL
            • Postgres
            • Redshift
            • Snowflake
            • SQL Server
        • Remote config
        • Smart proxy
          • Architecture
          • Implementation
        • 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
      • SQL Views
      • Performance
      • Advanced
        • Headers
        • Create Results
      • GitHub Actions CI
      • SSL termination
    • Custom
      • Query
      • Result
  • Cloud
  • Which Query Engine?
  • Backend
  • Identity and Multi-Tenancy
    • Node client
    • Python client
    • Ruby guide
    • Self sign
    • Quick start
    • 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
  • 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
    • Normalized data sets
    • Dynamic data sets
    • Query
    • Result
      • 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.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
    • Vizzly Query Engine
  • App
  • Documentation
  • Blog
  • Get started
  • Welcome
  • How does Vizzly work?
  • Standard or custom reporting
    • Local Query Engine & React
      • Introduction
      • Building dynamic data sets
      • Identifying users
      • Deployment
    • Programmatic dashboards
      • Introduction
      • Postgres setup
      • NodeJS Identity
      • React frontend
  • Frontend
  • Dashboard
    • Properties
      • Core
      • identity
      • queryEngineEndpoint
      • dataSets
      • data
      • runQueries
      • queryEngineConfig
      • Multiple dashboards
      • dashboardId
      • parentDashboardId
      • Customization
      • theme
        • Accordion
        • Buttons
        • Charts
        • Dashboard
        • Dropdowns
        • Forms
        • Headers
        • Library
        • Modals
        • Notifications
        • Lists
        • Panels
        • Tables
        • Tabs
        • Live Examples
      • featureToggles
      • textOverrides
      • Icons
      • Component overrides
      • labelFormat
      • dataPanel
      • formatPanel
      • excludeComponents
      • includeComponents
      • maxCSVDownloadLimit
      • numberFormatOptions
      • dateTimeFormatOptions
      • organizationName
      • developerTools
      • Event handlers
      • onEditorUpdate
      • onDashboardLoad
      • onViewClick
      • onDashboardFilterChange
      • trackEvent
      • Filters
      • dateFilterOptions
      • dashboardFilters
      • cascadeFilterSelection
      • Programmatic
      • parentDashboard
      • Scheduled Reporting
      • reportScheduleOptions
    • Theme and experience
    • Management
    • Log level
    • CSS
    • React
    • Quick Installation
    • Web component
    • Vue
    • HTML
    • Svelte
    • Angular
    • State Management
    • Setup
    • Filters
    • Controls
  • Services
    • Setup
    • Initializing
    • Building blocks
    • Views
      • Area Chart
      • Column chart
      • Line Chart
      • Pie Chart
      • Scatter Chart
      • Combo Chart
      • Pivot table
      • Basic Table
      • Single stat
      • Progress
      • Mercator Map
      • Horizontal bar chart
    • Cell
    • Header
    • Library
    • Row
    • Dashboard
    • Dashboard Manager
    • Initializing
    • Creating
    • Updating
    • Deleting
    • Fetching
  • Query Engine
  • In-browser
      • Integrations
      • Environment variables
      • Normalized
        • Building data sets
        • Config storage
          • Vizzly API
          • GitHub
          • AWS S3
      • Dynamic
        • Config
          • Schema
            • BigQuery
            • MariaDb
            • MySQL
            • Postgres
            • Redshift
            • Snowflake
            • SQL Server
        • Remote config
        • Smart proxy
          • Architecture
            • Sequence diagram
          • Implementation
        • 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
      • SQL Views
      • Performance
      • Advanced
        • Headers
        • Create Results
      • GitHub Actions CI
      • SSL termination
    • Custom
      • Query
      • Result
  • Cloud
  • Which Query Engine?
  • Backend
  • Identity and Multi-Tenancy
    • Node client
    • Python client
    • Ruby guide
    • Self sign
    • Quick start
    • 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
  • 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
    • Normalized data sets
    • Dynamic data sets
    • Query
    • Result
      • 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.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
    • Vizzly Query Engine

On This Page

  • Sequence diagram
Self-hosted
Vizzly Query Engine
Dynamic
Smart proxy
Architecture

Smart proxy architecture

To run Vizzly in a dynamic mode, the connection credentials and/or the config must be added to the request before they reach the Vizzly Query Engine.

This means pointing the queryEngineEndpoint property to your servers, to add the connection and/or config value to the request before forwarding it on to the Vizzly Query Engine.

Learn more about how to implement the smart proxy here

Sequence diagram