Week 66 - Snowpark & Python

It's been a while since we had a Snowpark challenge, has it not?

OK, take the following code:

import snowflake.snowpark as snowparkfrom snowflake.snowpark.functions import coldef main(session: snowpark.Session):tableName = 'snowflake.account_usage.tables'dataframe = session.table(tableName)return dataframe

And 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!