69931 - Accessing a VARIANT data type in Snowflake using SAS/ACCESS® Interface to Snowflake results in a data length of 0

SUPPORT / SAMPLES & SAS NOTES

Problem Note 69931: Accessing a VARIANT data type in Snowflake using SAS/ACCESS® Interface to Snowflake results in a data length of 0

If a Snowflake table contains a VARIANT data type, the length of the variable is 0 when the data is brought into SAS.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Product Family	Product	System	Product Release		SAS Release
Product Family	Product	System	Reported	Fixed*	Reported	Fixed*
SAS System	SAS/ACCESS Interface to Snowflake	Microsoft® Windows® for x64
SAS System	SAS/ACCESS Interface to Snowflake	Linux for x64
SAS System	SAS/ACCESS Interface to Snowflake (on SAS Viya)	Linux for x64	2020.1	Stable 2023.03	Viya platform	Viya platform

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

Type:	Problem Note
Priority:	high

Date Modified:	2023-04-05 11:37:19
Date Created:	2023-03-09 15:38:48