SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ55

Transform Data

A Data Engineer is creating a set of reporting tables to analyze consumer requests by region for each Data Exchange offering each year, along with click-through rates for every listing.

Which views are minimally required as data sources?

Explanation

SNOWFLAKE.DATA_SHARING_USAGE.LISTING_TELEMETRY_DAILY provides daily listing telemetry by data exchange and region, including REQUEST and LISTING CLICK events and their counts. These fields can be aggregated annually to report consumer requests by region and to calculate a click-through rate for each listing.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!