Use Query Results Cache in Snowflake

preview_player
Показать описание
Snowflake offers practically unlimited storage capacity of data, but more data also requires more computing resources to process. When all data sources are connected live to Snowflake, queries involves large amount of computer resources impacts both performance and cost of result retrieving process. In this talk Liu will go over how to minimize the effect, and discuss some practices to best leverage the cache store.

Chapters:
0:00 Intro
4:03 Demo
13:04 Using in Tableau

Links:

----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
  1. The Information Lab
  2. salesforce
  3. lets talk data
  4. data
  5. business intelligence
  6. snowflake
Рекомендации по теме
Use Query Results 0:22:47

Use Query Results Cache in Snowflake

Super fast queries 0:12:57

Super fast queries with Result Cache

Query Performance: Results 0:09:00

Query Performance: Results Cache

Cache Eloquent Query 0:05:43

Cache Eloquent Query Results to Load Pages Instantly

Result Cache 0:08:02

Result Cache

React Query Tutorial 0:08:06

React Query Tutorial - 6 - Query Cache

Easy PHP Caching 0:15:16

Easy PHP Caching in 15 minutes to improve performance - Cache MySQL query results

Codeigniter Cache Query 0:16:08

Codeigniter Cache Query Result Database Using PhpFastCache

Hibernate’s Query Plan 0:09:13

Hibernate’s Query Plan Cache: How It Works and How to Tune It

Enable the query 0:00:50

Enable the query cache in MySQL

Cache Query Result 0:14:46

Cache Query Result Database PHP Using PhpFastCache.com

React-query Cache in 0:01:25

React-query Cache in Local Storage with persistQueryClient

How to optimize 0:00:35

How to optimize and clean up your SQL using cache fields

React Query Tutorial 0:04:40

React Query Tutorial #5 - Query Cache

SQL : How 0:01:19

SQL : How to cache the query result of a function in oracle 10g?

SQL : How 0:01:22

SQL : How to disable using cache results in Redshift Query?

MySQL : The 0:01:45

MySQL : The most simple way to cache MySQL query results using PHP?

Drupal: Meaning of 0:01:55

Drupal: Meaning of 'Query results' and 'Rendered output' in Views cache?

Oracle Performance - 0:11:09

Oracle Performance - Result Cache Exercises

Hibernate 5-Query cache,entity 0:14:09

Hibernate 5-Query cache,entity cache and collection cache example

Efficient Function Calls 0:02:11

Efficient Function Calls From SQL (Part 3) : PL/SQL Function Result Cache

Hibernate: How to 0:06:07

Hibernate: How to Cache DTO Projections

#4: Cache Queries 0:08:31

#4: Cache Queries Results | Object Cache | 🚀 Quick Laravel Performance Tips 🚀

Hibernate Query Spaces: 0:07:18

Hibernate Query Spaces: Optimizing Flush & Cache Operations