claude-skills/tinybird-best-practices/rules/copy-files.md

Copy Pipe Files

• Do not create by default unless requested.
• Create under /copies.
• Do not include COPY_SCHEDULE unless explicitly requested.
• Use TYPE COPY and TARGET_DATASOURCE.

Example:

DESCRIPTION Copy Pipe to export sales hour every hour to the sales_hour_copy Data Source

NODE daily_sales
SQL >
    %
    SELECT toStartOfDay(starting_date) day, country, sum(sales) as total_sales
    FROM teams
    WHERE day BETWEEN toStartOfDay(now()) - interval 1 day AND toStartOfDay(now())
    and country = {{ String(country, 'US')}}
    GROUP BY day, country

TYPE COPY
TARGET_DATASOURCE sales_hour_copy
COPY_SCHEDULE 0 * * * *