Release - February 14th, 2022

✨ New ✨

Okta Single Sign-On

Details

Product Component

Security

More Detail

Transform now supports single sign-on with Okta. This integration supports both IDP and SP initiated login.

Okta administrators can add Transform as an application from Okta’s integration network and add users that should have access to Transform. Once enabled in Okta, you can follow the instructions provided to enable this using both Okta and Transform. In Transform, we’ve added a new Settings Tab called Security, which you will use to configure Okta.

Verification Steps

If your organization uses Okta, find Transform in Okta’s integration network. See our documentation for step-by-step instructions.

Better Model and Data Warehouse Validation

Details

Product Component

Metrics Framework

More Detail

We’ve introduced both improved model and data warehouse validation that will make developing and committing configs easier by catching the errors ahead of the model being committed and surfacing useful errors.

Some examples of improved validation included but are not limited to the following:

• Ensuring referenced tables exist in your fields and data warehouse
• Checking that SQL expressions are valid
• Making sure Inputs meet the expected constraints (e.g., name uniqueness, having a primary time dimension, ensuring you’ve completed all fields)
• Handling empty documents and Nonetypes.

Verification Steps

• Upgrade your MQL CLI via pip install --upgrade transform
• Run mql validate-configs with your model to see new validations. If there are no issues found, you will not observe many changes to the validation process.

Note that we are consistently adding more data warehouse-based validations, if you run into issues please reach out to us. Additionally, if you experience validation failures due to timeouts you can add --skip-dw to the validate-configs or commit-config commands.

New Organization Setup Flow

Details

Product Component

Metrics Catalog

More Detail

While mostly for new organizations using Transform, we wanted to call out that we’ve introduced a new organization creation flow in Transform. This feature allows you to fill out a form with information which when submitted will create your Transform organization, spin up your MQL server, and guide you to help connect Github with Transform. Previously, this work was manual.

For existing users of Transform with an active organization, you might notice the Installation page differs a bit and now shows each step in the setup flow.

Verification Steps

You should only follow this guide if you are creating a new Transform instance: visit https://app.transformdata.io/create_organization.

For existing users curious about the new setup flow, visit the new install page to see what this looks like.

Copy Last Day Value Menu Action

Details

Product Component

Metrics Catalog

More Detail

The same menu that contains the export CSV now has an option called "Copy Last Day's Values". This simply copies out the latest day of data. If there is a grouping applied, it will copy out each respective dimension and value in list form with the latest date. If there is no grouping applied, it will copy out a single day of data with the date. The copy is meant to allow for easy pasting into a tool like Google Sheets or Excel.

Verification Steps

Open up any chart menu and confirm you see this option.

🐛 Bug Fixes 🐛

Dimension Value Menu Selection Fix

Details

Product Component

Metrics Catalog

More Detail

We fixed a bug where dimensions with a large number of values could sometimes cause the page to be unresponsive (in the chart filter menu).

Verification Steps

Find a metric that has a dimension associated that contains a large number of cardinal values. Determine when you filter and choose from those dimensions in the filter that everything works properly.

Granularity Fill 0 Bug

Details

Product Component

Metrics Catalog

More Detail

For measure proxy metrics using SUM, SUM_BOOLEAN, and COUNT_DISTINCT aggregations, nulls should be replaced with 0 when a granularity is applied. We’ve fixed a bug where charts were not filling 0 for these metrics.

Verification Steps

Navigate to a metric page for a measure proxy metric using using SUM, SUM_BOOLEAN, or COUNT_DISTINCT aggregation. Use the chart filters to apply a granularity. When the chart reloads, you should see a continuous line with no gaps in data.