page334
422
Optimization code
time travel setting, 374
Out of memory (OOM), 88, 279, 282, 361,
369, 384, 403
P
Parallelization
curate, 271, 272
data master, 269
data products, 270
distribution venues, 274–277
global application, 270
ingest, 271
logging, 277
optimal data processing
curation factors, 285
ingest factors, 283, 284
problem statement, 278
warehouse factors, 279–282
parallel processing, 286
produce, 272–274
real-world production
environment, 314
Parallel processing
application tables, setting up,
288–290, 292–294
concurrent warehouse, 300–302
core table segmentation, 295,
296, 298–300
DML statement, 286
full processing unit consumption, 287
high-level design, 288
single processing unit
consumption, 286
stored procedure
create tables, 307–309
grant entitlement, 307
load testing, 311
purging stream, 309, 310
segment suffix, 304
suspend tasks, 311
testing single load, 306
stream interaction, 302
temporal loads, 312, 313
testing core table load, 294, 295
testing streams, 303
Parsing, 30
Partition Attributes Across (PAX), 115
Performance tuning approach, 59, 166
design
consumption metrics, 365, 366
CSP performance, 367
data modeling approach, 357
declare constraints, 360
logging, 358
managed accounts, 363
multiplatform distribution, 364, 365
optimizing consumption, 366, 367
platforms, 357, 358
replication, 364
role-based access control, 359, 360
snowflake edition costs, 356
transient/permanent tables, 361
warehouse, 361
workloads, 362
identifying issues
blocked transactions, 399
join explosions, 399, 400
long compilation time, 400
long execution time, 401
long table scan, 402
out of memory, 402
queueing, 397
spills to disk, 402
workload, 398
INDEX