page32
12
My experience of tuning highly complex ported queries shows an upward of a 20
percent performance improvement, which directly translates to a cost reduction. Once
the top 10 queries have been optimized, recheck and identify the next top 10 longest
running queries and repeat performance tuning.
Greenfield Development
Several steps are the same as with application migration though with different boundaries.
•
Planning: Develop a project plan incorporating scope, funding,
resources, and timeline.
•
Entitlements: Determine the application entitlement model
using RBAC.
•
Data model: Design and implement the application data model.
•
Data consumption: Create the application outbound data
consumption processes.
•
Platform security: I cover this point in great detail in the Maturing
the Snowflake Data Cloud book.
•
Performance: How to optimize Snowflake is the core subject matter
of this book.
•
Testing: Perform testing to ensure all functional and nonfunctional
requirements are met.
•
Documentation: No development activity is complete without
complete documentation.
I do not dwell on greenfield development as this is a well-trodden path with many
skilled practitioners ready and willing to undertake Snowflake development.
Replication Considerations
A distinct advantage of porting applications to Snowflake is the ability to utilize Secure
Direct Data Shares, Private Listings, and Snowflake Marketplace. As noted, you will also
incur costs when you replicate data across regions and when you egress data from one
CSP to another external location.
ChaptEr 1
tuning thE SnowFlakE Data ClouD