2

How to clear the table contents from information_schema.copy_history

history values so that i can use re-use the same values for copy...strong text

Sreeram
  • 21
  • 3
  • By "re-use the same values for copy" do you mean copy the same files into a table? If so, you don't need to clear out the copy_history view in the information_schema (and can't unless you drop or replace the table). You can specify FORCE = TRUE in your copy into statement. – Greg Pavlik Nov 19 '20 at 15:31

1 Answers1

0

Answering for completeness (curating the tags)

As per @Greg in the comments:

By "re-use the same values for copy" do you mean copy the same files into a table? If so, you don't need to clear out the copy_history view in the information_schema (and can't unless you drop or replace the table). You can specify FORCE = TRUE in your copy into statement.

Robert Long
  • 5,722
  • 5
  • 29
  • 50