Modern Data Stack in One Day
At Nimbus Intelligence Academy we are trained to build a modern data stack including data warehousing, ELT processes and scheduled refreshing of data. Each trai... Read more.
Snowflake setup in Airbyte
Fivetran and Airbyte are two tools that extract, load and possibly transform (the ELT process) data. The data can come from many different places, for example, ... Read more.
Snowflake setup in Fivetran
Fivetran and Airbyte are two tools that extract, load and possibly transform (the ELT process) data. The data can come from many different places, for example, ... Read more.
Custom generic test in dbt
Writing a custom generic test in dbt allows you to test your data on your own assumptions. For a project that we worked on, I have written a test to...... Read more.
REGEX in Snowflake
It is possible to match strings with regular expression (also called REGEX) in Snowflake. I think many data scientist, including myself, love this feature. As p... Read more.
Data validation in Snowflake
As a follow up of my previous blog on SQL injection into Snowflake, I made a small demo about data validation in Snowflake. Data validation is the practice of c... Read more.
Snowflake SQL Injection
SQL Injection has the potential to ruin your database. If you have heard of the webcomic xkcd, then you have most likely heard about Little Bobby Tables, or by ... Read more.
Automate external stage loading
This week I set-up automate external stage loading. I did this for our first mock datastack project with Snowflake and dbt. The main idea of the project is that... Read more.
Snowflake Numbers Quiz
Last Friday was our first attempt at the SnowPro Core certification exam, and I passed! While preparing for the exam, I made a Snowflake Numbers Quiz that I wan... Read more.
Wildcard searches in SQL and Python
Last week I found myself wondering about wildcard searches in SQL and Python. And to my own surprise, I found myself wishing for a SQL functionality in Python! ... Read more.
