page321
409
© Andrew Carruthers 2024
A. Carruthers, Tuning the Snowflake Data Cloud, https://doi.org/10.1007/979-8-8688-0379-6
APPENDIX
Installing Python and
the Tooling You Will Need
This appendix covers how to install the tooling referenced in Chapter 6.
Installing Python from the Command Line
Later in this appendix you will learn how to develop a Python parallel process to invoke
several concurrent queries. In conjunction with Chapter 6, I show how to invoke parallel
processes to simulate a load test as a starting point for stressing your applications to find
out where they could break.
Load testing serves several purposes:
•
Optimize your warehouse size for known workloads
•
Identify spills, queueing, blocking, and out-of-memory scenarios
•
Monitor trends to enable early intervention and prevent failure
In this appendix, I discuss how to install Python on your operating system; these
instructions are generic in nature and work for many common desktops.
In conjunction with Chapter 6 the testing in this appendix proves there are version
dependencies across both Snowflake-supported Python versions and tooling that may
not easily be resolved. This appendix assumes Microsoft Windows 10.