Hashquery

A Python framework for modeling and querying business data inside of your data warehouse

Logic shouldn’t be trapped in any tool, especially not your BI tool. But data teams are often forced to choose between doing their modeling with proprietary DSLs like LookML or adding complex business logic into raw SQL, where it can’t be easily re-used or extended. That’s why we’re building hashquery.

Hashquery expressions are defined in Python, compiled into SQL, and run directly against your data warehouse. It is capable of expressing complex, multi-layered data queries, way beyond the capabilities of standard SQL. It natively integrates with upstream semantic layers. And unlike a DSL, hashquery is fully composable and extensible — it’s just Python.

Attention

Hashquery is currently in public preview. Here are some caveats to keep in mind for early adopters:

• Backwards compatibility may not be preserved between version upgrades, and you may need to update your package regularly.

• There may be differences in the SQL logic generated by hashquery compared to the Hashboard app.

• You may encounter dialect-specific SQL syntax errors or other unexpected errors. If you come across one, let us know by reporting an issue.