How to Find Files from the Command Line - Using `find` and `fzf`
👉 Sign up for the newsletter: https://kpdata.dev/newsletter/ Boost productivity by finding files from the command…
Load Data to Snowflake - How to Get CSVs into Snowflake with COPY INTO
👉 Sign up for the newsletter: https://kpdata.dev/newsletter/ Snowflake makes it easy to analyze data. The hardest…
Slowly Changing Dimensions - What are SCD Types?
👉 Sign up for the newsletter: https://kpdata.dev/newsletter/ Good data modeling updates records without losing the…
Python Else Statement - What Else Does "Else" Do? - The 4 Places "Else" Works
You've probably used "else" with the if-statement. But what about for-loops? Where can the "else" statement be used?…
Python Decorators - How Do Decorators Work? - Create Custom Decorators
You've seen that @ symbol but aren't sure what it does. It's time to unravel the Python decorator. We'll see how…
Python Scope - What Is NameError and UnboundLocalError? - How Python Finds Names
Life's good until you hit that NameError or UnboundLocalError. Avoid unnecessary pain by mastering Python scope. We'll…
What Is A Parquet File? - Structure of Parquet - Encoding Optimizations
Parquet is all over the modern data stack. But do you understand how it works? We'll explore the Parquet format and…
Python Parameters - What's that / and * doing there? - And what is *args and **kwargs?
Level up your python functions by using those asterisks and slashes you've been avoiding. 👉 Sign up for the…