-
Notifications
You must be signed in to change notification settings - Fork 3
/
staging_data_commands.sql
33 lines (16 loc) · 2.07 KB
/
staging_data_commands.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
COPY staging.batchdate FROM 'C:/Users/Rishika Gupta/Desktop/tpc-di-benchmark/sf_3/output_data/Batch1/BatchDate.txt';
COPY staging.cashtransaction FROM 'C:/Users/Rishika Gupta/Desktop/tpc-di-benchmark/sf_3/output_data/Batch1/CashTransaction.txt' delimiter '|';
COPY staging.dailymarket FROM 'C:/Users/Rishika Gupta/Desktop/tpc-di-benchmark/sf_3/output_data/Batch1/DailyMarket.txt' delimiter '|';
COPY staging.date FROM 'C:/Users/Rishika Gupta/Desktop/tpc-di-benchmark/sf_3/output_data/Batch1/Date.txt' delimiter '|';
COPY staging.holdinghistory FROM 'C:/Users/Rishika Gupta/Desktop/tpc-di-benchmark/sf_3/output_data/Batch1/HoldingHistory.txt' delimiter '|';
COPY staging.hr FROM 'C:/Users/Rishika Gupta/Desktop/tpc-di-benchmark/sf_3/output_data/Batch1/HR.csv' delimiter ',' CSV;
COPY staging.industry FROM 'C:/Users/Rishika Gupta/Desktop/tpc-di-benchmark/sf_3/output_data/Batch1/Industry.txt' delimiter '|';
COPY staging.prospect FROM 'C:/Users/Rishika Gupta/Desktop/tpc-di-benchmark/sf_3/output_data/Batch1/Prospect.csv' delimiter ',' CSV;
COPY staging.statustype FROM 'C:/Users/Rishika Gupta/Desktop/tpc-di-benchmark/sf_3/output_data/Batch1/StatusType.txt' delimiter '|';
COPY staging.taxrate FROM 'C:/Users/Rishika Gupta/Desktop/tpc-di-benchmark/sf_3/output_data/Batch1/TaxRate.txt' delimiter '|';
COPY staging.time FROM 'C:/Users/Rishika Gupta/Desktop/tpc-di-benchmark/sf_3/output_data/Batch1/Time.txt' delimiter '|';
COPY staging.tradehistory FROM 'C:/Users/Rishika Gupta/Desktop/tpc-di-benchmark/sf_3/output_data/Batch1/TradeHistory.txt' delimiter '|';
COPY staging.trade FROM 'C:/Users/Rishika Gupta/Desktop/tpc-di-benchmark/sf_3/output_data/Batch1/Trade.txt' delimiter '|' null as '';
COPY staging.tradetype FROM 'C:/Users/Rishika Gupta/Desktop/tpc-di-benchmark/sf_3/output_data/Batch1/TradeType.txt' delimiter '|';
COPY staging.watchhistory FROM 'C:/Users/Rishika Gupta/Desktop/tpc-di-benchmark/sf_3/output_data/Batch1/WatchHistory.txt' delimiter '|';
COPY staging.audit FROM 'C:/Users/Rishika Gupta/Desktop/tpc-di-benchmark/sf_3/output_data/Batch1_audit.csv' DELIMITER ',' HEADER CSV NULL AS '';