A subquery is a query that is used in another query. Another example of subqueries can be as simple as the example below. A correlated subquery is a subquery where a reference is made to the outer query. An uncorrelated subquery is a subquery where no reference is made to the outer query. For the…
Imagine that you want to load semi-structured data in the form of JSON into Snowflake. If the JSON contains an outer array and if you did not strip it, the entire dataset would be loaded into a single row in the target table. Sometimes that is acceptable and you can process the data in a…
Tasks are an excellent scheduling tool in Snowflake. You can use tasks for a lot of different purposes. Below are some examples: The scheduling can be done using CRON (for example, run a task every hour, minimum schedule is one minute) or using a trigger. You could trigger a task to run after another task…
A stream is a great way to track changes to a source table in #Snowflake. These tracked changes can then be used to create an incremental load for example. There are 3 types of streams: – Standard: tracks all data manipulation changes to an object. – Append-only: tracks only inserts. – Insert-only: tracks only inserts…
Ever encounter a python script with a “lambda” lurking somewhere in the blocks of code? Didn’t know what to make of it? I’ve got you covered… Put simply, a lambda function is a small anonymous function. It is mostly used for cases that do not require a separate function for whatever reason. Syntax is relatively…
Some time ago I wanted to find out if values in certain columns started with the letter “a”. I used the Power Query M function Text.StartsWith() in combination with an IF statement. A problem occurred: whenever Text.StartsWith() gets a null as input, it returns a null. If you feed an IF statement a null, instead…
Imagine you want to compare budget VS actuals but the budget is incomplete. There is a limited amount of time, so completing the budget manually is not an option. We’ll use actuals wherever budget amounts are missing. So far so good. But wait a second… what is that? The Power BI Measure Totals are incorrect…
Get a thousand separator for multiple columns in Power BI at once with a single click? Go to “Model view” Select the columns that you want a thousand separator for Turn on the thousand separator Get years of your life back
Een week geleden schetste ik een voorbeeld van twee folders waarvan de inhoud enige overlap heeft. De bestanden die in folderA voorkomen, maar NIET in folderB, werden in dat voorbeeld geïdentificeerd. Maar dit kan beter …! In het Python script wat via de onderstaande link te vinden is, wordt wederom gekeken naar de niet-overlappende bestanden.…
If you ever feel redundant… Just remember that this guy felt the need to replicate the bare bones of a function that was already present in Windows for decades.
