Release Notes¶

October 2024¶

You may now set monthly spend limit and configure alerts to help control your Blue cluster costs.
New ODBC connector is now available.
Direct connector to PowerBI is now available.
Ability to use specific Resource Pool for the creation of column statistics.

You may now read, write, and query data from Snowflake.
A clusteradmin can now enable View cluster jobs to view all the Jobs of all users.

We’ve improved the DESCRIBE COLUMNS command, allowing you to list information about VIEW columns.
We now support the ARRAY data type.
Blue now supports metalanguage scripting.
New Dashboard items
New activity page
You can now manage your query execution queue through the Blue web interface.
SQream Blue can now be deployed on Amazon Web Services (AWS)
The use of DESCRIBE SESSION QUERIES with the ALL parameter, previously available only to a SUPERUSER, is now available to all system users.

Introducing new Dashboard charts for monitoring and responding to system changes:
- Worker Loads
- Queued Statements
- Jobs
- Tasks
We’ve improved the DESCRIBE SESSION QUERIES command, allowing SUPERUSER roles to investigate multiple sessions.
You now have the ability to grant temporary access to a BLUE support team member. This feature is beneficial for having our support team validate usage and perform checks on your specific environment.

The DESCRIBE SESSION QUERIES command now provides the name of the resource pool used with each query execution.
With a new filter, you can now choose to concentrate on either user-initiated or system-initiated operations when monitoring your daily workflows through the DESCRIBE SESSIONS and AUDITLOG commands.
Use the new IsCastable function to safely check if a cast operation is supported for a given column and data type, providing an alternative within a CASE statement when an exception occurs.

Now, through the UI, you can terminate executed jobs, especially useful in cases of delays or resource consumption. It’s beneficial when a job awaits a resource held by another job or different cluster users, preventing issues during execution.
Users can seamlessly transfer existing jobs between clusters, crucial for data teams looking to expedite data movement tasks.
The integration of Python scripts into database operations enhances automation, allowing users to schedule and execute routine tasks efficiently, reducing manual effort and minimizing errors. Python’s scripting flexibility enables agile development, fostering an iterative and responsive approach to database job creation.

BLUE now leverages Apache Calcite for precise query interpretation, transforming queries efficiently with its algebraic representation and cost-based optimizer.
You can seamlessly share Jobs with specific team members, streamlining workflow and project expansion.
The new CLI table view feature enhances data querying in BLUE, offering improved readability and organization, along with visual representations for easier comprehension and navigation.

You can now schedule jobs with greater precision, choosing hourly or minute-based execution for SQL workflows.
Regarding security, our recent penetration test successfully addressed all SOC2 Type 2 findings, strengthening our security measures.
We introduced character limits within JSON scripts for Job and task names and descriptions to enhance system security.

Quickly check Worker availability with the Resource Availability Status, distinguish active clusters from suspended ones, and resize your BLUE cluster as needed for enhanced parallelism.
The AUDITLOG command now offers insights into essential client actions, including system events and resource management.

Introducing the new DESCRIBE POOLS Command, listing existing resource pools and configurations, like pool name, allocation count, policies, and ID.
Boost efficiency with multi-statement execution, executing multiple SQL statements in one script.
Explore the new BLUE dashboard with Job action metrics, tracking job and task statuses for enhanced performance insights.

Explore the capabilities of Jobs, a versatile SQL workflow management tool automating complex sequences of SQL scripts for seamless data preparation and insights delivery.
Optimize resource utilization with the Resource Pool panel, efficiently managing costs and enhancing cluster performance.

Auth0’s powerful capabilities empower BLUE to provide IDP authentication, multi-factor authentication, encryption, and anomaly detection, ensuring robust user data protection and access control.
Benefit from automatic suspension and resumption of your BLUE environment, efficiently managing resources during inactivity.
BLUE is now available on the Google Cloud Platform (GCP) Marketplace, streamlining deployment for enhanced flexibility and scalability.