Problem Note 67420: SAS/ACCESS® Interface to Google BigQuery changes the default data type used from TIMESTAMP to DATETIME while creating Google BigQuery tables
 |  |  |  |  |
When SAS/ACCESS Interface to Google BigQuery creates a Google BigQuery table from a SAS table, the default data type is changed.
If the SAS column has a DATETIME or DATEAMPM format, then the engine or data connector will change from creating a TIMESTAMP column to a DATETIME column.
If you require the original behavior of creating a TIMESTAMP column, you must use EXPLICIT SQL code to create and insert data to the Google BigQuery table.
Click the Hot Fix tab in this note to access the hot fix for this issue.
The hot fix introduces this new behavior beginning with SAS/ACCESS® Interface to Google BigQuery 9.41.
After applying the hot fix, if your Google BigQuery tables still use TIMESTAMP data types, see SAS Note 67943 regarding an issue that you might encounter.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Google BigQuery | Linux for x64 | 9.4 | 9.43 | 9.4 TS1M6 | 9.4 TS1M8 |
Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdatesA fix for this issue for SAS/ACCESS Interface to Google BigQuery 9.42 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/K2L.html#67420A fix for this issue for SAS/ACCESS Interface to Google BigQuery 9.41 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/H5A.html#67420| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2021-05-26 14:11:08 |
| Date Created: | 2021-02-12 03:56:20 |