Image courtesy: https://resources.snowflake.com/solution-briefs/snowflake-cloud-data-platform-solution-brief

Building Snowpipe on Azure Blob Storage Using Azure Portal Web UI for Snowflake Data Warehouse

Snowpipe is a built-in data ingestion mechanism of Snowflake Data Warehouse. It is able to monitor and automatically pick up flat files from cloud storage (e.g. Azure Blob Storage, Amazon S3) and use the “COPY INTO” SQL command to load the data into a Snowflake table.