Over the course of my career, I have learned about quite a few qualities that team members can possess that add value to the team. Many of these strengths are fairly obvious: being willing to work hard, prioritizing tasks properly to meet deadlines, not becoming siloed and unaware of what other team members are doing, … Read more
Oftentimes, when looking at the Advanced Editor window on a Power BI query, you will see that the SQL query in one of the steps has been compressed into fewer lines – perhaps even only one line; minified with Power Query codes like “#(lf)” (line feed) and “#(tab)”. To make this more readable, you can … Read more
Finding metadata regarding table and column names in Redshift can be daunting, especially if you do not know if the tables are internal or external. Redshift has a table called SVV_EXTERNAL_COLUMNS that is useful for looking at external tables, and there are scripts to look at internal tables as well. The SQL code I wrote … Read more