Skip to Main Content
Marketscape Insights Idea Center
Status Will not implement
Categories User Experience
Created by Pierre Menard
Created on Apr 1, 2022

Performance improvement for customers with large numbers of aliases

Currently Marketscape creates a temp db table in Snowflake for customer specific aliases and joins to that table to return results back to Marketscape.

A better approach would be to run the Snowflake query without joining to an alias temp table, and apply the aliases as a secondary step right before display. Customers would see a noticeable performance improvement, while also avoiding unnecessary copying of data to Snowflake.

  • Attach files
  • Liz Gombosi
    Reply
    |
    Apr 22, 2022

    Sounds good Pierre! I'll pop this into Will Not Implement

  • Pierre Menard
    Reply
    |
    Apr 1, 2022

    actually never mind. This might not be a good idea since customers often search on alias as well. Please disregard.