# mkdir ~/sample_pj
And you have to put SQL file and Data.
~/sample_pj
|__export
|__sqls: Transform data with SQL
|__source: csv or excel
Create Data {table name}.csv
sample_pj/source/sample.csv
a,b,c
1,2,3
4,5,6
Create SQL {SortNo}.{sql name}.sql sample_pj/sqls/0.delete.sql sample_pj/sqls/1.create.sql
0.delete.sql
drop table if exists a_sum;
1.create.sql
create table if not exists a_sum as
select sum(a) as "合計" from sample;
Create SQL {sql name}.sql sample_pj/export/export.sql
export.sql
select * from a_test
$ datapine etl --path ~/sample_pj
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent