Splunk has released security updates to address a critical security flaw in Splunk Enterprise that could be exploited to conduct unauthenticated file operations and even remote code execution. The ...

Software engineer. Primary focus - Python & mathematics. Designing API servers and pipelines. Following my previous post about setting a function-level database setup, which is a junior-level solution ...

After Apache DolphinScheduler has been running for a period of time, the instance scheduling logs increase significantly and need to be cleaned up regularly. SQL ...

Make sure you specify the "read" dialect eg. parse_one(sql, read="spark") Make sure you specify the "write" dialect eg. ast.sql(dialect="duckdb") Check if the issue still exists on main SELECT ...

Sqlglot is switching date_trunc to timestamp_trunc upon parsing, which is not a valid Snowflake sql function. It is also switching the argument order and unquoting the date part where it shouldn't do ...

We have a bit of a tradition on the Power Fx team. As part of onboarding, new team members add a few functions to get up to speed on how the system works internally. Their learning is your gain in ...

We all have done some basic maths where we used to shorten a number with a lot of decimal digit. If Truncate and Round of sounds familiar, then you got it right. In this post, we will show how you can ...

The importance of automating processes can’t be overestimated. Most things start out as a manual procedure until you work out exactly how things should happen, but many times they stay that way ...