Chose skinClose

Track your consumption

use role accountadmin ;
select * from snowflake.account_usage.warehouse_metering_history limit 10;

select * from snowflake.account_usage.query_history limit 10


select 
    round(sum(credits_used*3.28),2) as billed_amount,
    warehouse_name,
    TIMESTAMPDIFF('minute',start_time,end_time) as warehouse_run_time_minutes,
    date(start_time) as execution_date,
    hour(start_time) as execution_hour
from snowflake.account_usage.warehouse_metering_history
group by 2,3,4,5


select 
  count(distinct query_id) as total_queries_executed,
  case 
      when round(execution_time/6000) between 0 and 10 then '0-10 minutes'
      when round(execution_time/6000) between 10 and 20 then '10-20 minutes'
      when round(execution_time/6000) between 20 and 50 then '20-50 minutes'
      when round(execution_time/6000) between 50 and 100 then '50-100 minutes'
      when round(execution_time/6000) between 100 and 200 then '100-200 minutes'
      when round(execution_time/6000) between 100 and 200 then '200-300 minutes'
      when round(execution_time/6000) >300 then '300+ minutes'
  end as execution_time_range,
  nvl(warehouse_name,'Warehouse Cache') as warehouse_name,
  user_name,
  date(start_time) as execution_date,
  hour(start_time) as execution_hour
from 
    snowflake.account_usage.query_history
group by 2,3,4,5,6

# get cluster info  
select system$clustering_information('table_name')
# select table info
show tables like '%LINE%';

create or replace table 'table' cluster by (col)
as select * from database.schema.table;
# check query history
use role accountadmin;
select  * from table(snowflake.information_schema.query_history()) order by start_time;

# disabled cached 
ALTER SESSION SET USE_CACHED_RESULT = FALSE;

# optimization 
select system$ESTIMATE_SEARCH_OPTIMIZATION_COSTS('TABLE')
alter table 'table'' search optimization;
alter table 'table'' drop search optimization;