How to Duplicate a Table and Preserve Data

·

Question "Duplicate Table" duplicates the structure and logic - which is super useful How does one do "Duplicate Table" that ALSO duplicates the data with it?

1 comment

· Sorted by Oldest

Clay Team
APP
·
·
Great question! That's complicated to achieve from an engineering perspective because you'd likely duplicate enrichments columns, the way data is stored in them involves a unique API call. If data were to be duplicated, it would likely re-run these because it would consider them new calls in that table. Best way to get a copy of the data is to download the CSV and import it into the new one or use other tools like write to table or lookup to pull the data over. Of course, you could still run into the auto-enrichment issue, so just a heads up and to keep in mind.

Clay Team
APP
·
·
Great question! That's complicated to achieve from an engineering perspective because you'd likely duplicate enrichments columns, the way data is stored in them involves a unique API call. If data were to be duplicated, it would likely re-run these because it would consider them new calls in that table. Best way to get a copy of the data is to download the CSV and import it into the new one or use other tools like write to table or lookup to pull the data over. Of course, you could still run into the auto-enrichment issue, so just a heads up and to keep in mind.