page337
425
replication, 13
tune design, 13
use case, 4
Snowpark-optimized warehouses, 190
Snowpipe, 241
SnowSQL, 2
Subject-matter experts (SMEs), 5
T
Tokenization, 30
U
Unentitled data sharing
importing share, 334, 335
managed accounts, creating, 327–330
share containers, 329–332
unentitled object, 332, 333
User-defined functions (UDFs), 30, 396
User-defined objects
materialized views, 396
secure views, 395
tables, 394
UDFs, 396
views and dynamic tables, 395
V
Visual Studio, 2
W, X, Y, Z
Warehouse
background processing, 198
capacity, 192, 193
consumption, 192
declaration, 191, 192
initialization, 190
memory/compute, 189
performance tuning, 187
query tags, 198, 199
resolving concurrency issues
artificial size constraint, 221
auto-suspend setting, 220
consolidating workloads, 222, 223
object locking, 221, 222
reducing warehouse, 219
retiming processes, 220
snowpipe file size, 221
summaries/aggregates/filters, 220
resource consumption,
restrict, 237–240
scaling, 194–197
serverless compute
components, 241
monitor queueing, 244
QAS, 243
snowpipe, 241
tasks, 242
size and use considerations,
193, 194
tuning design
operations, 205
predictable workloads, 210
serial/parallel logging, 206–209
storage feature, 205
workload monitoring, 210–213, 215
workload queueing, 215–218
tuning effort, 187
types, 189, 190
workloads
default warehouse sizing, 200, 201
dynamic resizing, 204
segregation, 201, 202
size matters, 202, 203
typical consumption pattern, 200
INDEX