page333
421
J
Join explosion
cartesian join, 72
K
KISS principle, 25
L
lineitem_baseline_temp, 264
Load testing
external parallelism, 228–234
monitor queueing, 234–236
parallel loading, 225
performance evaluation, 224, 225
snowflake/CSP improvements,
223, 224
snowflake-supplied sample, 226, 227
tasks/streams, 227, 228
themes, 223
LOCK_TIMEOUT, 399
M, N
Massively parallel processing (MPP),
11, 33, 187
Micro-partitions
challenges, 141, 142
data lifecycle
cloned objects, 134–139
data consumptions, 129, 130
data ingestion, 123
data processing, 125–129
data sharing/replication, 139
fail-safe, 133
recovered objects, 132
setting baseline, 122, 123
table active storage, 140
time travel, 130–132
definition, 111
features, 103
foundational information
block devices, 107
centralized storage, 105, 106
database/table storage, 108
direct storage access, 106, 107
stages, 110, 111
storage costs, 107
immutability, 112, 113
metadata, 114
metadata query result, 112
setup, 104, 105
table metadata, accessing
account usage store, 116
GET_QUERY_OPERATOR_STATS,
118, 119
information schema, 115, 116
query profile, 117, 118
system$clustering_depth, 119
system$clustering_information, 120
time sensitive, 120–122
Microsoft PowerPoint, 3
Migration, Snowflake
CSP infrastructure, 7
guides, 8
options, 9–11
Multicluster compute, 187
O
Object locking, 222
Observe, Orient, Decide, Act (OODA), 188
Online analytical processing (OLAP), 153
Online transactional processing (OLTP),
4, 153, 206
INDEX