page278
366
Figure 10-4.
Multiplatform metric ingestion
Available consumption metrics will not include detailed SQL statements as these are
likely to contain consumer intellectual property. Snowflake explicitly prevents producers
from accessing their client SQL statements. Nonetheless, collated consumer metrics
offer a degree of insight. Note that each platform’s metrics may require conforming to a
certain format for reporting purposes.
Optimizing Consumption
When developing applications, you will usually focus on achieving both system
performance and cost to deliver data products. Usually this is a linear process deliver
to either “like-for-like” capability when porting from an existing application or to build
a minimum viable product for delivery to clients. Rarely do developers consider how
clients will interact with a data product.
When ingesting data and combining intellectual property to curate data products,
you must also consider adding features to facilitate client consumption of your data
products. Some attributes lend themselves to improving query performance at little to
no cost.
ChapTer 10
OpTimizing perfOrmanCe