Salesforce

Data Sharing Usage Views: Changes to Column in Views

« Go Back

Information

 
SummaryData Sharing Usage views updated to return snowflake_region instead of cloud + region.
Last Modified DateJanuary 21, 2023
Article Body

This behavior change is in the 2022_08 bundle. In the 6.35 release, the bundle is disabled by default.

For the most up-to-date details about the version and date in which it will be enabled, as well as other release-related details, see the Behavior Change Log.


All the views in the SNOWFLAKE.DATA_SHARING_USAGE schema have changed as follows:

Previously:

Data displayed in the SNOWFLAKE_REGION column in the views was displayed as <cloud> <region> in all lowercase (e.g. aws us_west_2). This was inconsistent with the values displayed for Snowflake region in the SHOW REGIONS output.

Impacted views:

  • LISTING_ACCESS_HISTORY  
  • LISTING_CONSUMPTION_DAILY
  • LISTING_EVENTS_DAILY
  • LISTING_TELEMETRY_DAILY

Currently:

In the views listed above, values in the SNOWFLAKE_REGION column are displayed now as <cloud>_<region> in all uppercase. This is consistent with the SHOW REGIONS output.

For example, the us_west_2 region in AWS is displayed as AWS_US_WEST_2.

 


Ref: 827

 

TitleData Sharing Usage Views: Changes to Column in Views
URL NameUpdate-usage-views-to-return-snowflake-region-instead-of-cloud-region
Category 
Sub Category 
Article Record TypeRelease Notes

Powered by