What is a Reference Table?
Hi, @archanask. The term “Reference” in the context of smart queries means that a particular table or smart query should be used only for reference purposes and not be included in Athena’s knowledge base. This is especially useful in cases where multiple smart queries are used to build one complex query, and each query has its own columns and metadata that are not essential for understanding the final result. By marking a table or smart query as “Reference”, it will not be loaded into Athena’s knowledge base, which can improve its overall understanding and query performance. I hope this explanation clarifies the concept for you.