---
title: "Append and replace modes in Copy Pipes"
excerpt: "Now it's possible to specify the insertion mode for Copy Pipes by setting the new attribute `COPY_MODE` in the datafile. And there is a new chart, the table component!"
date: "2024-06-28"
---

# Support for `append` and `replace` modes in Copy Pipes

It's now possible to specify the insertion mode for [Copy Pipes](/classic/work-with-data/process-and-copy/copy-pipes). This is done by setting the new attribute `COPY_MODE` in the datafile, with the possible values:

- `append`: Every execution will add the rows extracted by the Copy Pipe to the destination Data Source, incrementally.
- `replace`: Every run completely replaces the destination Data Source content with the rows generated in the Copy Pipe.

Here's an example:

```tb {% title="Example Copy Pipe with insertion mode REPLACE" %}
NODE all_orders
SQL >
    select * from orders

TYPE copy
TARGET_DATASOURCE orders
COPY_MODE replace
COPY_SCHEDULE @on-demand
```

## Tinybird Charts: New Table component

We're excited to introduce a powerful new addition to Tinybird Charts: The Table component!

This new component enhances your data visualization capabilities alongside the existing Chart components.

{% image src="/assets/changelog/tb_charts_table_component.png" alt="Tinybird Charts Table component" /%}

## Snapshots deprecation

The Snapshots feature will be deprecated next week, hiding the option to create new ones and removing the access to public ones. Remember to use the [Playground](/classic/work-with-data/query#use-the-playground) instead.

## Improvements

- You can now select the compression type for a Sink export from the UI.
- Although a node query will fail due to a 10 second timeout, it's now possible to create a resulting Copy Pipe.
- Fixed a problem when querying the organization Service Data Sources in a Branch.