Skip to content

Instantly share code, notes, and snippets.

@trungv0
trungv0 / query.py
Created October 13, 2023 15:40
frosty friday w066
# https://frostyfriday.org/blog/2023/10/06/week-66-intermediate/
import snowflake.snowpark as snowpark
from snowflake.snowpark import functions as F
def main(session: snowpark.Session):
tableName = 'snowflake.account_usage.tables'
dataframe = (
session.table(tableName)
.filter(
(F.col('row_count') > 0)