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 and restructure the report directly in Sigma, for example reducing the number of queries by using child elements, while in other cases I moved the more complex queries to Snowflake, where I created dedicated dynamic tables