Querying data warehouses with Numeracy is now even easier
We’ve shipped a number of improvements over the past month or so to make writing queries even better in Numeracy. These improvements work with databases like Postgres and MySQL to hosted data warehouses like BigQuery, Redshift, and Snowflake (and more).
Choose the schemas you care about
Data warehouses can have thousands of tables and dozens of schemas. Now you can include or exclude schemas when browsing the schema browser. Plus, only the schemas you include will appear in suggestions as you write your query.
Function autocomplete
You finally learned all of the functions Postgres supports and now your company uses BigQuery. The functions are just slightly different enough to trip you up. Now functions autocomplete with inline descriptions and links to documentation for whatever database you’re using.
Column annotations
Column annotations and descriptions shed light on columns that aren’t immediately obvious by name alone. Understand why columns exist and how to use them by reading the descriptions in the schema browser and autocomplete.
Balanced display of query and results
Get the most out of your screen real estate when you run a query. Numeracy automatically sizes the results pane to give you a good amount of space for both your query and the results. Drag the results pane to a different height if you prefer.
Results search
Numeracy has always made it easy to explore results by generating interactive stats and having a fast, non-paginated results table. Now you can search results to find exactly what you’re looking for. Column stats will update to reflect your refined results and you can download your search as a CSV.
Run portions of queries
Highlight a portion of query to run just that part. Write multiple queries and only run the one your query is in. Being able to write and run queries more flexibly keeps you in your flow.
Format queries
Hit cmd+shift+o to clean up your query. Cmd+z will return you to your original query if you liked it better before.
More improvements
We’ve made general improvements to Numeracy’s layout and design. Typography and syntax highlighting within queries have been refined to increase legibility.
We’re always improving existing features in Numeracy. We’re also working on powerful collaboration features that we’re excited to share with you soon.
—
Follow along here or on Twitter to get updates.
Sign up for a Numeracy trial today and start querying in minutes.