26 lines
644 B
Markdown
26 lines
644 B
Markdown
# 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 * * * *
|
|
```
|