Which Snowflake object enables loading data from files as soon as they are available in...

In Snowflake, a Pipe is the object designed to enable the continuous, near-real-time loading of data from files as soon as they are available in a cloud storage location. Pipes use Snowflake’s COPY command to load data and can be associated with a Stage object to monitor for new files. When new data files appear in the stage, the pipe automatically loads the data into the target table.

References:

Snowflake Documentation on Pipes

SnowPro® Core Certification Study Guide

https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html