Both options seem to be valid. As others mentioned:
B). https://docs.snowflake.com/en/user-guide/tables-external-intro. External tables are read-only. You cannot perform data manipulation language (DML) operations on them. However, you can use external tables for query and join operations. You can also create views against external tables.
D). https://docs.snowflake.com/en/sql-reference/sql/alter-external-table
Answer "B" is correct.
External tables are read-only. You cannot perform data manipulation language
(DML) operations on them. However, you can use external tables for query and join operations. You can also create views against external tables.
B
External tables are read only.
https://docs.snowflake.com/en/user-guide/tables-external-intro#:~:text=External%20tables%20are%20read%2Donly,create%20views%20against%20external%20tables.
Correct, so DML operations cannot be performed (INSERT, UPDATE, DELETE).
ALTER is DDL.
If you read the link you pasted carefully, you will find ALTER EXTERNAL TABLE statement.
Answer is D
Alter external table operates on the external table's metadata, not on the data in the external table itself. but queries and joins on the external table is allowed. B
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
azprepd
1 month, 1 week agoMatthieuDN
6 months, 3 weeks agoMultiCloudIronMan
7 months agoMitchdu
7 months, 2 weeks agoaral
8 months, 3 weeks agoMSIDDIQUI18
10 months agoMitchdu
7 months, 2 weeks agocharatepallavi07
1 year, 3 months agoede3703
1 year, 4 months agoVenkataPhaniPavanKumar
1 year, 4 months agoyaho5
1 year, 4 months agonexerSnow
1 year, 5 months agoVenkataPhaniPavanKumar
1 year, 5 months agoyaho5
1 year, 4 months ago56d43d6
7 months, 3 weeks agoNachoPrendes
1 year, 5 months ago