by 
It’s been a while since we had a Snowpark challenge, has it not?
OK, take the following code:
Start Up Code
import snowflake.snowpark as snowpark
from snowflake.snowpark.functions import col
def main(session: snowpark.Session):
tableName = 'snowflake.account_usage.tables'
dataframe = session.table(tableName)
return dataframeAnd edit it so you get the following result:
There are three conditions:
1 – the table must not be transient
2 – the table must not have been deleted
3 – the table must have more than 0 rows
This should be done in a Python worksheet!
Good luck!
3 responses to “Week 66 – Intermediate”
-
It’s always fun seeing the Python challenges. It’s a good reminder that Snowflake isn’t restricted to just SQL. Thanks!
- Solution URL – https://github.com/ChrisHastieIW/Frosty-Friday
-
I’ve been following the Frosty Friday challanges for a while, but only now I found the time to tackle the proposed challange. Hope this will become a habbit 🙂
https://github.com/Al3x-M/Frosty_Friday/blob/main/W66/Week_66.py
-
Nice bit of practice with dataframes
- Solution URL – https://github.com/ChrisBo94/FrostyFriday/blob/main/Week_66.py
Leave a Reply
You must be logged in to post a comment.