Soumak Das
1 min readSep 14, 2023

--

Snowflake has recently introduced an exciting feature that allows SQL commands EXECUTE IMMEDIATE FROM to be triggered directly from files stored in an internal stage. These files can contain SQL statements or scripting blocks.

The EXECUTE IMMEDIATE FROM command is designed to execute SQL statements specified within a file located in a Snowflake stage. This file can comprise both SQL statements and Snowflake Scripting blocks, but it’s imperative that all statements are syntactically correct SQL.

This command offers a versatile means to execute statements from any Snowflake session, granting users control over the deployment and…

--

--

Soumak Das

Sr. Data Engineer @EY & Snowflake/Airflow/Databricks/AWS writer