Snowflake External Table Vs Query on Stage…Pros & Cons

Photo by Gabriella Clare Marino on Unsplash

This blog is going to be a very informative blog. One of my friends asked me what would be my thought on using Snowflake External table VS directly querying on External stage ? At the end both are doing the same thing query external file and givings us data than what's the difference and what are the pros & cons for using one on top of others. Before we start with actual discussion let's get…