Snowflake bundle 2023_05
With the release of the Snowflake 2023_05 bundle, you'll notice adjustments in the behavior of SOLE and MATE and tag management. The bundle is enabled by default. Further details are outlined in the topics below.
Validation of file formats options in SOLE
With this bundle, Snowflake improves the validation when creating or updating file formats in a database. Check out the Snowflake Documentation for more information.
Previously, SOLE didn't throw any error message if a stage or file format was created with invalid file format options. Currently, if the existing stage or file format configurations in SOLE are incorrect, the SOLE jobs will fail in a pipeline.
Output of failed grants
With this bundle, Snowflake changes the output of a failed grant. Check out the Snowflake Documentation for more information.
Previously, if a grant query failed due to insufficient privileges, the query failed, but SOLE and MATE silently ignored the grants that could not be applied. Currently, the grant query will return an error, which will cause the SOLE or MATE jobs applying the grant to fail.
Role permission to view tags
With this bundle, Snowflake is changing the permissions required to manage tags that are shared through a data share. Check out the Snowflake Documentation for more information.
Previously, a role with the required privileges to access the shared schema that stores tags could view all of the shared tags. Currently, a role needs the READ privilege to a tag within the schema to view that tag.
EoL MATE with dbt version 1.0
We strongly recommend upgrading your DataOps projects to a later supported dbt version, such as 1.4 or 1.5, for better performance and access to breaking changes. See Switching dbt version for information.
Improvement Creating users automatically via SSO
We have introduced a new self-serve Single Sign-On (SSO) user creation process that significantly enhanced our authentication system by streamlining the experience for new users and administrators. Users with the appropriate SSO permissions can now independently access the DataOps.live platform by using this new user creation process without the help of our support team.
See automatic user creating via SSO for more details.