Snowflake Connector Release Notes

Alation Cloud Service Applies to Alation Cloud Service instances of Alation

Customer Managed Applies to customer-managed instances of Alation

February 28, 2024

Snowflake OCF Connector: Version 2.3.0

Enhancements

Docker CIS Benchmark Compliance

Snowflake OCF connector versions 2.3.0 and newer are now compliant with the following Docker CIS benchmarks:

  • Docker 4.1 - Ensures that a user for the container is created

  • Docker 4.6 - Ensures that HEALTHCHECK instructions are added to container images

  • Docker 4.7 - Ensures that docker files do not include update instructions as a standalone or single-line instruction

Additional Checks for QLI

Snowflake OCF connector now checks the inclusion of queryString, startTime, or sessionID column in the view or custom query used for QLI. If the queryString, startTime, or sessionID column is missing, the connector displays an error message and a hint in the Job summary. This check prevents log flooding.

January 31, 2024

Snowflake OCF Connector: Version 2.2.15

Fixed Issue

Alation Prevents Completion of Test Connection and Test Access and Fetch Actions Without System Views Access

You can now complete the Test Connection and Test Access and Fetch Schema actions on the General Settings and Metadata Extraction tabs, respectively, even when your configured service account cannot access system views but would like to use custom views instead.

In such cases, Alation now displays a warning message allowing you to proceed if you intend to use Custom MDE Queries to configure and run extraction. This functionality was blocked in connector version 2.2.13 and has now been re-introduced.

January 03, 2024

Snowflake OCF Connector: Version 2.2.13

Fixed Issues

Compose Uses Incorrect Version of the JDBC Driver

Snowflake OCF connector supports the latest JDBC driver version (version 3.14.1). However, Compose is unable to use the latest version of the JDBC driver and falls back to the native version.

December 13, 2023

Snowflake OCF Connector: Version 2.2.11

Compatible Alation Version - 2022.4 or higher

Enhancements

The allowUnderscoresInHost Parameter is Automatically Set in the JDBC URI

If you miss setting the allowunderscore parameter in the JDBC URI field on the General Settings tab of the Snowflake data source, the Snowflake OCF connector automatically sets the allowunderscore parameter to true (allowunderscore=true).

With this enhancement, Snowflake OCF connector supports underscores in the account names included in the Privatelink JDBC URLs.

Fixed Issues

Metadata Extraction Fails In the Absence of ALLOWED_VALUES Column

In Snowflake OCF connector version 2.2.9 and earlier, Alation introduced a new column called ALLOWED_VALUES in the Tag extraction query to extract all the available values associated with the ALLOWED_VALUES parameter from the Snowflake data source. If this column is absent in the custom query for the tag, MDE fails.

This column has now been made optional to ensure that MDE runs successfully for users who have installed the latest Snowflake OCF Connector version (2.2.9 and higher) on an earlier Alation version.

November 16, 2023

Snowflake OCF Connector: Version 2.2.9

Compatible Alation version: 2022.4 or higher

Enhancements

With Alation version 2023.3.2.1 and Snowflake OCF connector version 2.2.9, Alation has introduced an enhanced user interface for configuring the Snowflake data source settings.

Note

The connector version is compatible with Alation versions prior to 2023.3.2.1. However, you will view the old user interface with Alation versions prior to 2023.3.2.1.

The documentation for the new Snowflake experience is available at Snowflake OCF Connector.

The enhanced user interface provides the following features:

Improved User Experience

The enhanced Snowflake Admin user interface provides better navigation and multiple visual cues, making it easy to configure and manage Snowflake data source.

Easy to Connect

The Snowflake Admin user interface now provides a step-by-step process to connect to your Snowflake data source easily and quickly.

Extra Error-Prevention Checks

The Snowflake Admin user interface now includes added checks to avoid obvious configuration mistakes. The user interface also includes text to assist and provide cues while configuring.

Actionable Error Messages and Detailed Error Reports

The Snowflake Admin user interface has made troubleshooting easier for metadata extraction and query log ingestion, as you can now have actionable error messages. We also support a detailed error report for Metadata Extraction, which contains a detailed error description and steps to resolve the issue.