Virtual Environments for your Python Projects
All experienced programmers recommend creating a virtual environments for every Python project. Let’s see if we can get comfortable using them. PythonR... Read more.
Incremental Models in dbt
As your organization grows, so will your tables. A full rebuild of your models might become too time-consuming for business needs. To help keep large databases ... Read more.
Killing JSON: Using Flatten to Load JSON Data
Welcome back to Killing JSON, the series in which I channel my frustration with loading data into teaching you something. Last week, we covered the ins and outs... Read more.
Killing JSON: The Flatten Function
Welcome to Killing JSON, a series in which I channel my frustration with loading data into teaching you something. Today, we’re talking about the FLATTEN ... Read more.
My First Snowday: Notebooks, ML, and AI
Snowflake hopes to ride the AI wave AI is booming, and Snowflake doesn’t want to get left behind. Their pitch: Snowflake’s core values and strengths hav... Read more.
Network Policies in Snowflake
In Snowflake, network policies enable the restriction of Snowflake account access by specifying blocked and allowed IP addresses for users. Let’s dive in.... Read more.
Data Clustering in Snowflake
Data clustering in Snowflake, a process of organizing related rows within micropartitions, is pivotal for efficient query performance. While Snowflake automatic... Read more.
Streamlit Applications: A Guide to Reactivity and Statefulness
In the latest project at Nimbus Academy, trainees explored the dynamic realm of Streamlit—a versatile Python module that transforms scripts into interactive w... Read more.
Understanding Boolean Indexing in Pandas
Pandas, the popular Python library for data manipulation and analysis, offers a plethora of techniques to filter and manipulate data. One of the most powerful a... Read more.
Why use a Non-Relational Database?
Non-relational databases are databases that don’t store data in a tabular schema. When data structure frequently changes, or when workload reaches million... Read more.
