Skip to content

Instantly share code, notes, and snippets.

View datadutch's full-sized avatar
🏠
Working from home

Johan van der Kooij datadutch

🏠
Working from home
View GitHub Profile
alter session set USE_CACHED_RESULT = FALSE;
alter session set query_tag = 'resultcache';
use warehouse benchmark;
alter warehouse benchmark set warehouse_size = XSMALL;
select c.*
from cost.altimate.store_sales_price sp
join cost.altimate.customer c
on sp.ss_customer_sk = c.c_customer_sk
where c_birth_country like '%REP%'