From what stage can a Snowflake user omit the FROM clause while loading data into a table?
From what stage can a Snowflake user omit the FROM clause while loading data into a table?
When loading data into a table in Snowflake, if the data files are located in the table stage, the FROM clause can be omitted. This is because Snowflake automatically assumes that the data files are in the table stage and checks for files there by default.
Confirmed, B, according to docs: "Note that when copying data from files in a table stage, the FROM clause can be omitted because Snowflake automatically checks for files in the table stage."
B correct - https://docs.snowflake.com/en/user-guide/data-load-local-file-system-copy
B - https://docs.snowflake.com/en/user-guide/data-load-local-file-system-copy