New Features and Improvements
AtScale contains the following new features and improvements.
New sml-converters CLI and SML SDK
AtScale now provides sml-converters, a CLI for converting semantic models to and from SML. Currently, sml-converters supports conversions from dbt to SML.
To support this functionality, AtScale also provides an open source SDK, which contains the SML object builders and other utilities required by sml-converters.
Both sml-converters and the SML SDK are available as npm packages. For more information, see the sml-converters repository on GitHub and the npm registry pages for sml-converters and the SML SDK.
ATSCALE-26439, ATSCALE-21489
Composite models in Design Center
You can now create composite models in Design Center. Previously, this functionality was only available via SML.
Composite models are made up of multiple other models that share dimensions, as well as calculations specific to the composite model itself. When you deploy a composite model, all of its referenced objects are deployed as a single model.
Composite models are a Public Preview feature.
For more information, see Working with Composite Models.
ATSCALE-22211
GitHub Apps integration
You can now configure AtScale to authenticate with GitHub using GitHub Apps. This provides GitHub users with an alternative to Design Center's standard authentication option of personal access tokens. For instructions on configuring GitHub App integration with AtScale, see Configuring Git Authentication with GitHub Apps. For information on how users log in using an app, see Connecting to Git.
ATSCALE-26537
Fact table query acceleration with constraint translation
Constraint translation enables the AtScale engine to translate dimension filter constraints in queries to fact table partition column constraints. When the data warehouse processes the query, it can use the additional partition column constraints to accelerate it.
Constraint translation is a Public Preview feature.
For more information on defining constraint translations in your models, see Using Constraint Translation for Fact Table Query Acceleration.
ATSCALE-22903
New workflow for adding InterSystems IRIS data warehouses
You can now create and manage InterSystems IRIS data warehouses from the Datasources panel in Design Center, rather than the Control Center. For more information, see Adding InterSystems IRIS Data Warehouses.
With this change, all supported data warehouses are now configured via the Datasources panel. As a result, the Data Warehouses page in Control Center has been removed.
ATSCALE-23889, ATSCALE-23890
New option for invalidating aggregates
You can now invalidate all aggregates for a deployed model. When an aggregate is invalidated, its status is changed to Inactive, so that it is cleared from the system by aggregate maintenance. This provides a way to remove unwanted aggregates; for example, before deploying a model from your development environment to production, you may want to clear aggregates created during testing.
To support this functionality, the Build tab for deployed catalogs contains a new Invalidate Aggregates option, which you can use to invalidate aggregates for each model.
Only users with the superuser_user role can invalidate aggregates.
For more information, see Invalidating Aggregates for a Deployed Model.
ATSCALE-27029
New workflows for applying model settings
You now apply model settings via the deployed catalog's Model Settings tab, rather than from the Workspace panel. Additionally, AtScale now provides a workflow for easily restoring all of a model's settings to their defaults.
For more information on the new workflows, see Configuring Model Settings.
ATSCALE-23225
Global settings now fully managed in the global settings repository
Global settings are now fully managed in the global settings repository. As a result, the Settings > Engine page of Control Center has been removed.
For more information on working with global settings, see Configuring Global Settings.
ATSCALE-23859
Enhancements to AtScale's add-in for Microsoft Excel
The AtScale add-in for Microsoft Excel has been updated and enhanced to streamline both the installation process and the workflow for creating connections to AtScale.
To use the new workflow for creating connections to AtScale, you must completely uninstall any older versions of the add-in, then install the new one.
For more information, see Connecting to Excel via the AtScale Add-In.
ATSCALE-26102
New API endpoints
The AtScale public API contains three new endpoints for the following:
- Blocking and unblocking aggregates.
- Creating and managing Snowflake data warehouses.
- Translating AtScale inbound queries to outbound data warehouse queries, without running them.
The query translation API is intended for use by Snowflake Cortex and requires a special license. For information, reach out to AtScale Support.
For more information, refer to the AtScale API documentation.
ATSCALE-26303, ATSCALE-27009, ATSCALE-25125