Snowflake Data Share Enhancements in 2024.05
Note:Changes made to the Snowflake data share are made available in the UAT and Production environments close to the release dates of FlexNet Operations, but might not directly coincide with the release dates.
The following enhancements were made to the Snowflake data share:
In the Snowflake data share, the following columns have been renamed, and their data type has changed from “number” to “timestamp”. The aim of this schema change is to enhance the data that Revenera customers can retrieve from Snowflake.
|
Table |
Previous Column Name |
New Column Name |
|
SEC_VW_DEVICE and SEC_VW_DEVICE_HISTORY |
CREATE_DATE_ID |
CREATE_DATE |
|
EXPIRATION_DATE_ID |
EXPIRATION_DATE |
|
|
LASTMODIFIED_DATE_ID |
LASTMODIFIED_DATE |
|
|
EVENT_DATE_ID |
EVENT_DATE |
|
|
SEC_VW_ENTITLEMENT and SEC_VW_ENTITLEMENT_HISTORY |
CREATED_ON_ID |
CREATED_ON |
|
EXPIRATION_DATE_ID |
EXPIRATION_DATE |
|
|
LASTMODIFIED_DATE_ID |
LASTMODIFIED_DATE |
|
|
START_DATE_ID |
START_DATE |
|
|
VERSION_DATE_ID |
VERSION_DATE |
|
|
SEC_VW_FULFILLMENT and SEC_VW_FULFILLMENT_HISTORY |
EXPIRATION_DATE_ID |
EXPIRATION_DATE |
|
LASTMODIFIED_DATE_ID |
LASTMODIFIED_DATE |
|
|
EXPIRATION_DATE_ID |
EXPIRATION_DATE |
|
|
START_DATE_ID |
START_DATE |
Important:Snowflake integrations dependent on the affected tables and columns will need to be updated to support the new column names and timestamp data type.