hard20 pts · first answer countsdata-warehousingsnowflakeperformance
A query that spills to remote storage
Snowflake's query profile shows a large join with many GB 'spilled to remote storage', and the query is very slow. What is the usual fix?
Discussion 0
Join free to post in the discussion.
Related questions
- Partitioning a big tableData Engineer
- Kimball versus InmonData Engineer
- OLTP and OLAP workloadsData Engineer
- Why warehouses store columnsData Engineer
- Facts and dimensionsData Engineer
- Star versus snowflake schemaData Engineer
- Slowly changing dimension type 1Data Engineer
- ETL compared with ELTData Engineer