SQL query variablesQuery variables

Scale reporting with query variables

Define flexible variables so business users can safely customize and refresh reports.

PopSQL query variables view
hero background image

PopSQL is trusted by 2000+ of the world's top data teams

No-code customization

Empower business users

Let business users and execs customize their own reports without requiring an analyst for every question.

Empower business users with PopSQL

Protect analyst time

Let analysts focus on high-impact projects, rather than repeat ad-hoc requests. On average, analysts save 40 hours per month.

Save 40 hours per month with PopSQL

Flexible ways to customize reports

  • PopSQL multiple types

    Multiple types

    PopSQL supports multiple variable types: string, number, date, boolean, dropdown, and multiselect.

  • PopSQL If / else statements

    If / else statements

    SQL doesn't support if/else statements or variables out of the box. PopSQL makes your SQL dynamic with Liquid.

  • PopSQL works with dashboards & schedules

    Works with dashboards & schedules

    Query variables can be used outside your query too. Use it to power dashboards or recurring schedules for stakeholders.

  • SQL-powered variables

    SQL-powered variables

    Write a query to update dropdown and multiselect lists dynamically.

Why PopSQL?

PopSQL enables your team to leverage existing infrastructure and tooling, elevating your workflow.

Enterprise grade security illustration

Enterprise grade security

SOC 2 and GDPR compliance, SSO/SCIM integrations, versatile database connectivity, and precise access controls.

Useful APIs illustration

Useful APIs

API endpoints for query management and scheduling.

Connect to Git illustration

Connect to Git

Keep track of every change and review PRs with Git.

PopSQL is trusted by the best

Trusted by the best

Hear firsthand from our esteemed customers about what sets us apart.

  • Mike Doll profile pic

    Mike Doll

    Head of Data & Analytics, Udacity

    There weren't any tools on the market with a comparable solution.

    Read case study
  • Fabi Prabhakar profile pic

    Fabi Prabhakar

    Engineering Director, Branch

    I couldn't find another tool that was as pricing friendly and did what we needed the way PopSQL does.

    Read case study
  • Cody Clayton profile pic

    Cody Clayton

    Analytics Lead, theScore

    With the team now all working remotely, we found it so much easier to use Shared Connections via SSH.

  • Robert Ma profile pic

    Robert Ma

    Business Operations, Darwin

    Shareable queries and real time in-app collaboration are a game changer.

    Read case study
  • Steve Strates profile pic

    Steve Strates

    Software Engineer, Scruff

    Query variables make it easier for people to have access to data that matters without knowing SQL.

  • Peter Du profile pic

    Peter Du

    Data Scientist, Drop

    Looker has a lot of predefined things, but PopSQL gives me more flexibility for writing SQL and visualizing it straight away.

popsql logo

The most powerful workspace for data teams