Search…
⌃K
Links
🎉

What's New

Release Notes for new product functionality

December 6, 2022

  • Calculated fields on metrics, aka Secondary Calculations​
    • Add calculated fields to your visualization including period over period, period to date, prior period, and rolling window

November 28, 2022

  • Personalize your home page with Tags!
    • Use the 'Filter by Tags' buttons to see popular metrics and datasets with specific tags
Filter popular objects in Rasgo by their Tags

November 14, 2022

  • Tags!
    • Want to organize your datasets, queries, and metrics for easy browsing? Now you can with 🏷 tags!
  • dbt Cloud integration
    • Rasgo will automatically ingest dbt cloud metadata about your models and metrics so you can use them instantly! Follow these instructions to setup the Integration:

November 7, 2022

  • Categories on queries
    • Now you can categorize your queries just like you can with datasets
  • Static argument values in accelerators
    • Want to hard code an argument value so that your users don't have to manually input everything? Now you can!
Set static values for accelerator arguments

October 31, 2022

  • 🎃👻🎃👻
  • Activity Feed
    • See a feed of events tied to your datasets and metrics in the Activity tab
New Activity Feed
  • New tabs for metrics
    • Trends to analyze your metric
    • About to see metadata and description
    • Data sample of the dataset that this metric is part of
    • Activity for the event feed

October 26, 2022

  • Transform Manager
    • Manage your accelerators and transforms in one spot
    • Find the transform manager by clicking on your initial in the top right corner of the app and then selecting Manage Transforms

October 21, 2022

  • New Dataset Tabs!
    • About tab now includes both the user-created description and all Rasgo and Data Warehouse metadata
    • Data Sample moved to the Data tab
    • Lineage moved to the Lineage tab
New Dataset Tabs
  • Multiple Owners on a Dataset
    • Now you can add multiple people as owners on a dataset instead of just one

October 20, 2022

  • Home Page!
    • Search, import data, and see the most popular datasets and metrics all in one place

October 17, 2022

  • Global Search
    • Search for any metadata in Rasgo and find all of the metrics, datasets, and queries that match
    Global search results preview
    ​
  • Column Dictionary
    • Document your column labels and descriptions using markdown in Rasgo!
    • Find the column dictionary as a tab on any Rasgo Dataset
Columns tab on a Dataset

October 11, 2022

  • 1-Click Metric Comparison
    • Metric profiles have a shiny new "Compare With" button that lets you choose 1 or more metrics to add to the visualization... and they don't even have to be in the same dataset!
Compare With on Metric Profile

October 1, 2022

  • Refresh Dataset
    • One button to click when you need to sync changes from your data warehouse to Rasgo
    • For Rasgo datasets, Refresh Dataset will re-run the SQL to generate the dataset
    • For datasets registered directly from your data warehouse, Rasgo will just re-sync the table schema
Refresh Dataset button is under the Dataset options menu.
  • Date part bug fix
    • Updated the list of available date parts to include all valid options, as dictated by your data warehouse

September 27, 2022

  • New Navigation!
    • We're saving your mouse, one click at a time...
    • Three main tabs (Metrics, Datasets, Queries)
    • Relevant sub-tabs based on which item you select in the list
    • Use the '<' button on the sidebar to collapse it when you need to focus 😎
    ​

September 19, 2022

  • CTEs Everywhere
    • All queries created in Rasgo will now run as CTEs until they are saved as Datasets
    • This is a purely technical change to minimize the number of objects created and tracked in the data warehouse
  • User verification
    • Datasets and their associated metrics can optionally have an 'Owner' specified
    • Once selected, the 'Owner' can Verify the datasets and metrics so that other users know they can trust them
  • Ratio Metrics
    • Add a metric of type 'Expression' to create ratio metrics or other mathematically computed metrics
    ​

September 12, 2022

  • Filter Enhancements
    • Filtering columns just got a whole lot easier with auto-complete and new filter types for checking against a list of values
Is In List Filter with Typeahead Auto-Complete

September 3, 2022

  • No more Rasgo versioning
    • Ability to overwrite an existing dataset with a new query via the UI
    • Rasgo does not track versions, but supports roll-back to an old iteration of a dataset via an offline artifact (we recommend automatically storing these in Git using our Git Integration)
    • A Rasgo dataset maps 1:1 to a fully-qualified table name in your data warehouse
  • PyRasgo version 2.0.0!
    • Ability to overwrite an existing dataset, which will change the SQL logic that creates the associated fully-qualified table name
    • Publish new datasets from offline artifacts with rasgo.publish.dataset_from_dict()

August 30, 2022

  • Toggle and see the underlying chart data when you're looking at a chart
'Show Chart Data' / 'Hide Chart Data' toggles the chart data table view
  • SQL Mode in all filters!
Construct your own WHERE clause in filters, by clicking 'SQL Mode'. Toggle back to the form with 'Form Mode'.
  • Calendar date-picker for filters on date columns

August 26, 2022

  • Metric Deep Links
    • When you get that metric chart looking just right, you should be able to share it... now you can! Just copy the URL and it will preserve your date settings, group bys, and filters
    ​

August 22, 2022

  • GitHub Integration!
    • Rasgo integrates with your code repository via our new GitHub app
    • Once you install the app via https://app.rasgoml.com/profile, any changes made in Rasgo will automatically update the Rasgo branch in your repo and trigger a pull request to merge the changes to Main branch
  • Dataset + Metric Verification via Git
    • Datasets and Metrics now have verification statuses when viewed in the Rasgo UI, driven by our new GitHub integration
    • When datasets or metrics are created or edited, triggering the pull request in GitHub, they are marked as 'In Review'
    • Merging the pull request triggers an update for Rasgo to mark the included datasets or metrics as 'Verified'

August 10, 2022

  • Code View on the canvas
    • See all of the SQL generated in your canvas by selecting the 'Code View' tab
    • Make changes directly in the 'Code View' tab, and overwrite the 'No-Code View'

August 1, 2022

  • Drafts show on their own tab on home page: My Drafts
    • Datasets tab only shows 'Published' datasets
  • Markdown editor for descriptions
    • Create and preview markdown descriptions on your datasets
  • Show 10 unique values for a column when adding a filter
Markdown Editor
Preview of Distinct Values for a Filter
​

July 25, 2022

  • Metric-aware chart builder
    • Build charts using a mix of metrics and regular columns
    • Supports group by for dimension drill down, filters, pre-built time ranges, and more!

July 11, 2022

  • Metrics!
    • View metrics on the home page with the new metrics tab
    • Publish metrics on a dataset
    • Explore metric values via the metric profile page
    • Metric sparklines, via metric values cached in your warehouse and updated at the time grain frequency of the metric (i.e. daily metrics update each night)
    • For more info:

July 6, 2022

  • ​
    ⭐
    Favorites: Click the
    ⭐
    on your favorite datasets to make sure they always show up at the top on the home page

July 5, 2022

  • Updated Access Data experience, via the 'Access Data' button on the top right of every dataset page

June 29, 2022

  • Multiple dashboards in Insights: Support for multiple dashboards in a single dataset, using tabs
Support for multiple tabs in dashboards
​

June 21, 2022

  • ​SQL Generator, a free tool that enables anyone to generate a complex SQL query without writing a line of code
​

May 17, 2022

​
📣
Dashboards
📣
​
  • Each time you add a new chart, it will get dropped into the dashboard alongside existing charts
  • You can drag and resize each chart window to adjust the layout of your dashboard
​

May 6, 2022

  • Exporting datasets to dbt: added rasgo.publish.dbt_project() function to convert datasets into dbt project files