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
      Drop here to upload
    • 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.