Query variables
Scale reporting with query variables
Define flexible variables so business users can safely customize and refresh reports.
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.
Protect analyst time
Let analysts focus on high-impact projects, rather than repeat ad-hoc requests. On average, analysts save 40 hours per month.
Flexible ways to customize reports
Multiple types
PopSQL supports multiple variable types: string, number, date, boolean, dropdown, and multiselect.
If / else statements
SQL doesn't support if/else statements or variables out of the box. PopSQL makes your SQL dynamic with Liquid.
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
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.
Do more with dbt Coreâ„¢
Connect to your dbt project and go from data engineering to analysis in seconds.
Works with any database
PopSQL supports every major database provider out there.
Enterprise grade security
SOC 2 and GDPR compliance, SSO/SCIM integrations, versatile database connectivity, and precise access controls.
Useful APIs
API endpoints for query management and scheduling.
Connect to Git
Keep track of every change and review PRs with Git.
Trusted by the best
Hear firsthand from our esteemed customers about what sets us apart.
Mike Doll
Head of Data & Analytics, UdacityThere weren't any tools on the market with a comparable solution.
Read case study->Fabi Prabhakar
Engineering Director, BranchI couldn't find another tool that was as pricing friendly and did what we needed the way PopSQL does.
Read case study->
Cody Clayton
Analytics Lead, theScoreWith the team now all working remotely, we found it so much easier to use Shared Connections via SSH.
Robert Ma
Business Operations, DarwinShareable queries and real time in-app collaboration are a game changer.
Read case study->
Steve Strates
Software Engineer, ScruffQuery variables make it easier for people to have access to data that matters without knowing SQL.
Peter Du
Data Scientist, DropLooker has a lot of predefined things, but PopSQL gives me more flexibility for writing SQL and visualizing it straight away.
