https://medium.com/analytics-and-data/jinja-the-sql-way-of-the-ninja-9a64fc815564nn nnJinja Templates in Data EngineeringnHow they can be used in data engineeringnJinja template can help in implementing Dynamic SQL. Dynamic SQL helps generalize the SQL code that is being created. In Python, there are alternative to Jinja templates such as building string statements to achieve this goal. Still, there are a few advantages of using…
Jinja’s lower Test: Case-Sensitive Checks nThe Jinja lower test is a specific and useful tool for verifying that all cased characters in a string are lowercase. This test returns True if the string contains no uppercase characters, and False otherwise. It is a vital tool for validating data, ensuring consistency in user-submitted text, and performing…
Jinja’s none Test: Handling Missing Values The Jinja none test is a fundamental tool for checking if a variable’s value is None. This test is essential for preventing errors when trying to access attributes or perform operations on a variable that hasn’t been assigned a value. It’s a cornerstone of defensive programming in templates, allowing…
n What is the Jinja list Filter? nThe Jinja list filter is a simple but essential tool used to convert an iterable into a list. This filter is useful when you have a value that might not be a list—like an iterator, a string, or a dictionary—and you need to perform list-specific operations on it,…
n Understanding the unique Filter nThe unique filter is a handy tool in Jinja for removing duplicate items from a list or any other iterable. It processes a sequence of items and returns a new sequence containing only the unique elements. A key feature is that it preserves the original order of the items, based…
Transforming Data with Jinja Filters n nnJinja filters are powerful tools for transforming or modifying variables directly within your templates. They let you change the appearance of data—such as formatting a date, converting text to uppercase, or sanitizing HTML—without needing to write complex logic in your application code. Filters are an essential part of keeping…
Controlling Whitespace in Jinja Templates n nnJinja templates, by default, can introduce unwanted whitespace (extra lines, spaces, or tabs) into your rendered HTML. This often happens around block tags like {% if %} or {% for %}, which, when on their lines, leave behind blank lines. Jinja provides powerful configuration options and manual controls to…
Jinja2 Operator: ~ (Tilde) n nnThe ~ operator in Jinja2 is a concatenation operator used to join multiple operands into a single string. When you use the tilde, Jinja2 automatically converts all operands (including numbers, boolean values, and other data types) into their string representation and then joins them together. This is a very convenient…
Jinja Arithmetic Expression: // n nnThe // operator in Jinja2 is an arithmetic operator that performs integer division. It divides the first number by the second and returns the truncated integer result, discarding any fractional part. This is useful when you need to know how many times one number fits into another without concern for…
Jinja Block Assignments Introduction n n Jinja’s block assignment feature allows you to capture a multi-line block of content and assign it to a variable. This is a powerful and elegant solution for creating multi-line strings, which is a common task in templates and can be cumbersome with single-line assignments. The block assignment is a…