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.
Sounds good Pierre! I'll pop this into Will Not Implement
actually never mind. This might not be a good idea since customers often search on alias as well. Please disregard.