support.sas.com
 
 
support.sas.com


SAS/ACCESS Interface to Google BigQuery 9.42

Hot Fix Downloads for Linux for x64

* Important changes to Hot Fixes!

K2L001 was replaced by K3N003

K3N001 was replaced by K3N003

K3N002 was replaced by K3N003

K3N003 for Linux for x64
SAS/ACCESS Interface to Google BigQuery 9.42
Issue(s) Addressed:Introduced:
67025 Variables defined as a NUMERIC data type in Google BigQuery might be read into SAS® as a different value K3N001
66712 A generated list of BigQuery tables might be empty when the BigQuery dataset (schema) contains an underscore in its name K3N001
66871 Dates read in from a Google BigQuery database might show a difference from what is stored in the database K3N001
66996 The ability to use BigQuery Storage API has been added to SAS/ACCESS® Interface to Google BigQuery K3N001
66997 Improvements on the length of the STRING data type determination have been added to SAS/ACCESS® Interface to Google BigQuery K3N001
67015 An incorrect format might be added to a column that is defined as a BOOLEAN or a NUMERIC data type in the Google BigQuery database K3N001
67127 Materialized views are not included in the list of tables for Google BigQuery K3N001
67420 SAS/ACCESS® Interface to Google BigQuery changes the default data type used from TIMESTAMP to DATETIME while creating Google BigQuery tables K3N001
67421 A query against Google BigQuery tables might result in the message "...Error: googleapi: Error 403: Response too large to return..." K3N001
67539 SAS® might display an error when you attempt to delete a Google BigQuery view K3N001
67566 The TRIM function might be included in a query that is passed to the BigQuery database K3N001
67567 A query that includes the UNION of two queries that reference a Google BigQuery table might result in a performance issue and error K3N001
67638 Querying a Google BigQuery database might result in the message "Error: During read: googleapi: Error 403: Response too large to return error..." K3N001
67689 An error might occur when you create a new BigQuery table using a PROC SORT of a BigQuery table with a date equal to 31DEC9999 K3N001
67707 Unexpected characters might be appended to the end of a value on a string variable in a Google BigQuery table when it is read into SAS® software K3N001
67750 Inserting data into a Google BigQuery table using the FEDSQL procedure might result in errors K3N001
67754 ALERT - The option setting for the options used to connect to Google BigQuery with OAuth authentication might be displayed in clear text in logs K3N001
67758 Trying to access a Google BigQuery external table might result in an error K3N001
67974 Poor performance occurs when data is read from Google BigQuery views with the OBS= data set option K3N001
67908 ALERT - The setting for the CRED_PATH= LIBNAME and CREDFILE= CASLIB options might be displayed in cleartext in logs K3N002
68200 ALERT - A value that is stored as a NUMERIC data type might be read into SAS® with a different value than how it is stored in a Google BigQuery table K3N003
Released: September 10, 2021     Documentation: K3N003la.html       Download: K3N003la.zip  
Top ^




PLEASE CAREFULLY READ THE TERMS AND CONDITIONS OF THIS LICENSE AGREEMENT ("AGREEMENT") BEFORE DOWNLOADING MATERIALS FROM THIS SITE. BY DOWNLOADING ANY MATERIALS FROM THIS SITE, YOU ARE AGREEING TO THESE TERMS.
You are downloading software code ("Code") which will become part of a product ("Software") you currently have licensed from SAS Institute Inc. or one of its subsidiaries ("the Institute"). this Code is designed to either correct an error in the Software or to add functionality to the Software. The code is governed by the same agreement which governs the Software. If you do not have an existing agreement with the Institute governing the Software, you may not download the Code.
SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand and product names are registered trademarks or trademarks of their respective companies.

Copyright © 2021 SAS Institute Inc. All Rights Reserved.