Which command allows for continuous loading of data files as soon as they are available in a stage?
Which command allows for continuous loading of data files as soon as they are available in a stage?
CREATE PIPE is the command that allows for continuous loading of data files as soon as they are available in a stage. When a pipe is created, it sets up a continuous data loading process, monitoring the specified stage for new data files and then loading the data into a table.
https://docs.snowflake.com/en/sql-reference/sql/create-pipe