Description
Consulting, Optimization
Technologies
SQL, Sigma Computing, Snowflake
Problem
A company contacted me to perform an analysis of their workbooks on Sigma Computing and refactor them to optimize the SQL queries and simplify their structure to make them easier to manage.
Solution
I analyzed all the workbooks and identified the ones that were the most complex and slow, and that had a structure different from the standard used by the company.
For each report, I designed and implemented a refactoring:
- in some cases, it was enough to rewrite the SQL queries to make them more efficient or to optimize them by adding ad hoc indexes
- in other cases, it was necessary to redesign the report, for example, by reducing the number of queries through the use of child elements
- in some other cases, it was necessary to move the most complex queries to Snowflake, where I created dedicated dynamic tables and optimized performance by working with cached data