A user has 10 files in a stage containing new customer dat a. The ingest operation completes with no errors, using the following command:
COPY INTO my__table FROM @my__stage;
The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.
If the user runs the same copy into command what will happen?

Question

A user has 10 files in a stage containing new customer dat a. The ingest operation completes with no errors, using the following command:

COPY INTO my__table FROM @my__stage;

The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.

If the user runs the same copy into command what will happen?

David Llamas Ampudia · Accepted Answer

All data from all of the files on the stage will be appended to the table

David Llamas Ampudia · Answer

Only data about new customers from the new files will be appended to the table

David Llamas Ampudia · Answer

The operation will fail with the error uncertain files in stage.

David Llamas Ampudia · Answer

All data from only the newly-added files will be appended to the table.

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 110 - COF-R02 discussion

Suggested answer: A

0 comments