AppAppDocumentationDocumentationBlogBlog
  • Get started
  • Welcome
  • How does Vizzly work?
  • Get started
    • Local Query Engine & React
      • Introduction
      • Postgres setup
      • NodeJS Identity
      • React frontend
      • Introduction
      • Dynamic Data Set
      • Creating the Dynamic Query Engine
  • Frontend
  • Dashboard
      • 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
      • dataPanel
      • formatPanel
      • excludeComponents
      • includeComponents
      • developerTools
      • maxCSVDownloadLimit
      • numberFormatOptions
      • organizationName
      • Event handlers
      • onEditorUpdate
      • onViewClick
      • onDashboardFilterChange
      • Filters
      • dateFilterOptions
      • dashboardFilters
      • cascadeFilterSelection
      • Scheduled Reporting
      • reportScheduleOptions
    • Theme and experience
    • Management
    • Distribution
    • Log level
    • CSS
    • React
    • Quick Installation
    • Web component
    • Vue
    • HTML
    • Svelte
    • Angular
  • Semantic Layer
    • In-browser
      • Integrations
      • Normalized data structure
        • Building data sets
        • Config storage
          • Vizzly API
          • GitHub
          • AWS S3
      • Dynamic data structure or DB connection
        • Config
          • Schema
            • BigQuery
            • MariaDb
            • MySQL
            • Postgres
            • Snowflake
        • Smart Proxy
        • Local
        • Amazon Web Services
          • AWS App Runner
            • Adding secrets
            • IAM role
            • App runner service
        • Google Cloud Platform
          • GCP Cloud Run
        • Heroku
      • Environment variables
      • Performance
      • Advanced
        • Headers
        • Create Results
      • GitHub Actions CI
      • SSL termination
    • Custom
      • Query
      • Result
  • Backend
  • Identity and Multi-Tenancy
    • Node client
    • Python client
    • Self sign
    • Quick start
    • Property explanations
      • Project ID
      • User Reference
      • Secure Filters
      • Scope
      • Data Sets
      • Advanced
      • Access type
      • Parent Dashboard IDs
      • Database Schema Access
    • Load your private key from an environment variable
    • Key Pair
  • Webhooks
    • Get started
    • Scheduled reports
  • Support
  • CLI
  • Slack
    • Parent & child dashboards
    • Data set
    • Field
    • Verified views
    • Advanced
    • Time format
    • Data type
    • View attributes
    • Query
    • Result
      • 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.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.0
      • 0.3.0
      • 0.2.7
      • 0.2.4
      • 0.2.3
      • 0.2.2
      • 0.2.0
      • 0.1.11
      • 0.1.5
      • 0.1.4
      • 0.1.13
      • 0.1.6
  • App
  • Documentation
  • Blog
  • Get started
  • Welcome
  • How does Vizzly work?
  • Get started
    • Local Query Engine & React
      • Introduction
      • Postgres setup
      • NodeJS Identity
      • React frontend
      • Introduction
      • Dynamic Data Set
      • Creating the Dynamic Query Engine
  • Frontend
  • Dashboard
      • 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
      • dataPanel
      • formatPanel
      • excludeComponents
      • includeComponents
      • developerTools
      • maxCSVDownloadLimit
      • numberFormatOptions
      • organizationName
      • Event handlers
      • onEditorUpdate
      • onViewClick
      • onDashboardFilterChange
      • Filters
      • dateFilterOptions
      • dashboardFilters
      • cascadeFilterSelection
      • Scheduled Reporting
      • reportScheduleOptions
    • Theme and experience
    • Management
    • Distribution
    • Log level
    • CSS
    • React
    • Quick Installation
    • Web component
    • Vue
    • HTML
    • Svelte
    • Angular
  • Semantic Layer
    • In-browser
      • Integrations
      • Normalized data structure
        • Building data sets
        • Config storage
          • Vizzly API
          • GitHub
          • AWS S3
      • Dynamic data structure or DB connection
        • Config
          • Schema
            • BigQuery
            • MariaDb
            • MySQL
            • Postgres
            • Snowflake
        • Smart Proxy
        • Local
        • Amazon Web Services
          • AWS App Runner
            • Adding secrets
            • IAM role
            • App runner service
        • Google Cloud Platform
          • GCP Cloud Run
        • Heroku
      • Environment variables
      • Performance
      • Advanced
        • Headers
        • Create Results
      • GitHub Actions CI
      • SSL termination
    • Custom
      • Query
      • Result
  • Backend
  • Identity and Multi-Tenancy
    • Node client
    • Python client
    • Self sign
    • Quick start
    • Property explanations
      • Project ID
      • User Reference
      • Secure Filters
      • Scope
      • Data Sets
      • Advanced
      • Access type
      • Parent Dashboard IDs
      • Database Schema Access
    • Load your private key from an environment variable
    • Key Pair
  • Webhooks
    • Get started
    • Scheduled reports
  • Support
  • CLI
  • Slack
    • Parent & child dashboards
    • Data set
    • Field
    • Verified views
    • Advanced
    • Time format
    • Data type
    • View attributes
    • Query
    • Result
      • 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.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.0
      • 0.3.0
      • 0.2.7
      • 0.2.4
      • 0.2.3
      • 0.2.2
      • 0.2.0
      • 0.1.11
      • 0.1.5
      • 0.1.4
      • 0.1.13
      • 0.1.6
Self-hosted
Vizzly Query Engine
Dynamic data structure or DB connection
Config
Schema
BigQuery

BigQuery Config

SchemaMariaDb