Snowflake
COF-R02 · Question #54
True or False: You can query the files in an External Stage directly without having to load the data into a table.
The correct answer is A. True. External tables are read-only, therefore no DML operations can be performed on them; however, external tables can be used for query and join operations. Views can be created against external
Data Loading and Unloading
Question
True or False: You can query the files in an External Stage directly without having to load the data into a table.
Options
- ATrue
- BFalse
How the community answered
(34 responses)- A85% (29)
- B15% (5)
Explanation
External tables are read-only, therefore no DML operations can be performed on them; however, external tables can be used for query and join operations. Views can be created against external
Topics
#external stage#querying staged files#data loading
Community Discussion
No community discussion yet for this question.