What's New in Version 1.22.0
Version 1.22.0 of the relationalai Python package is now available!
To upgrade, activate your virtual environment and run the following command:
pip install --upgrade relationalaiNew Features and Enhancements
Section titled “New Features and Enhancements”-
You can now share your Snowflake
connections, and other settings, across projects instead of copying them into every project’sraiconfig.yaml. PyRel now discovers a home-level~/.rai/raiconfig.yamlconfiguration file and merges it with each project’sraiconfig.yaml, so you define shared settings once. Previously, a project file that only named a shared connection (default_connection: my_conn) failed, because PyRel couldn’t find where that connection was defined.For example, define a connection once in the home file, then reference it by name from any project:
# ~/.rai/raiconfig.yaml — define the connection onceconnections:my_conn:account: MY_ACCOUNTuser: MY_USERrole: MY_ROLEwarehouse: MY_WHdefault_connection: my_conn# raiconfig.yaml — in a project; no connection details needed heredefault_connection: my_connAnything you set in a project file still wins, so per-project overrides keep working. Not sure where a setting is coming from? Run
rai config:explainto trace each value to its file. -
You can now deploy a model from Python code by passing a
configtoModel, instead of deploying from araiconfig.yamlfile. For those deploys, therai doctor reporttroubleshooting report is now accurate. Before this release, it could show parts of your deployment as missing. Now it reflects the configuration your deploy actually used.
Bug Fixes
Section titled “Bug Fixes”-
Improved performance for queries against deployed models that compute several aggregates grouped by the same key with
per. Before this release, PyRel compiled these queries to SQL that repeated the same grouping join far more times than needed, so they ran slower while still returning correct results. Now the generated SQL is much smaller and runs faster. -
Fixed how PyRel references a Snowflake database, schema, or table used as a data source whose quoted name contains a period, such as a table named
"CoNNec.tioNs". Before this release, PyRel split the name on every period and produced an incorrect table reference. Now it keeps the quoted name intact.