-
Notifications
You must be signed in to change notification settings - Fork 4
Expand file tree
/
Copy pathcopy_commands_initial_data_load.sql
More file actions
23 lines (23 loc) · 3.52 KB
/
copy_commands_initial_data_load.sql
File metadata and controls
23 lines (23 loc) · 3.52 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
copy call_center from 's3://yourbucketname/manifest/tpcdscallcenter.manifest' iam_role 'arn:aws:iam::<your_account_number>:role/<your_role_name>' manifest;
copy catalog_page from 's3://yourbucketname/manifest/tpcdscatalogpage.manifest' iam_role 'arn:aws:iam::<your_account_number>:role/<your_role_name>' manifest;
copy catalog_returns from 's3://yourbucketname/manifest/tpcdscatalogreturns.manifest' iam_role 'arn:aws:iam::<your_account_number>:role/<your_role_name>' manifest;
copy catalog_sales from 's3://yourbucketname/manifest/tpcdscatalogsales.manifest' iam_role 'arn:aws:iam::<your_account_number>:role/<your_role_name>' manifest;
copy customer from 's3://yourbucketname/manifest/tpcdscustomer.manifest' iam_role 'arn:aws:iam::<your_account_number>:role/<your_role_name>' ACCEPTINVCHARS manifest;
copy customer_address from 's3://yourbucketname/manifest/tpcdscustomeraddress.manifest' iam_role 'arn:aws:iam::<your_account_number>:role/<your_role_name>' manifest;
copy customer_demographics from 's3://yourbucketname/manifest/tpcdswebcustomerdemographics.manifest' iam_role 'arn:aws:iam::<your_account_number>:role/<your_role_name>' manifest;
copy date_dim from 's3://yourbucketname/manifest/tpcdsdatedim.manifest' iam_role 'arn:aws:iam::<your_account_number>:role/<your_role_name>' manifest;
copy household_demographics from 's3://yourbucketname/manifest/tpcdsdhouseholddemographics.manifest' iam_role 'arn:aws:iam::<your_account_number>:role/<your_role_name>' manifest;
copy income_band from 's3://yourbucketname/manifest/tpcdsincomeband.manifest' iam_role 'arn:aws:iam::<your_account_number>:role/<your_role_name>' manifest;
copy inventory from 's3://yourbucketname/manifest/tpcdsinventory.manifest' iam_role 'arn:aws:iam::<your_account_number>:role/<your_role_name>' manifest;
copy item from 's3://yourbucketname/manifest/tpcdsitem.manifest' iam_role 'arn:aws:iam::<your_account_number>:role/<your_role_name>' manifest;
copy promotion from 's3://yourbucketname/manifest/tpcdspromotion.manifest' iam_role 'arn:aws:iam::<your_account_number>:role/<your_role_name>' manifest;
copy reason from 's3://yourbucketname/manifest/tpcdsreason.manifest' iam_role 'arn:aws:iam::<your_account_number>:role/<your_role_name>' manifest;
copy ship_mode from 's3://yourbucketname/manifest/tpcdsshipmode.manifest' iam_role 'arn:aws:iam::<your_account_number>:role/<your_role_name>' manifest;
copy store from 's3://yourbucketname/manifest/tpcdsstore.manifest' iam_role 'arn:aws:iam::<your_account_number>:role/<your_role_name>' manifest;
copy store_returns from 's3://yourbucketname/manifest/tpcdsstorereturns.manifest' iam_role 'arn:aws:iam::<your_account_number>:role/<your_role_name>' manifest;
copy store_sales from 's3://yourbucketname/manifest/tpcdsstoresales.manifest' iam_role 'arn:aws:iam::<your_account_number>:role/<your_role_name>' manifest;
copy time_dim from 's3://yourbucketname/manifest/tpcdstimedim.manifest' iam_role 'arn:aws:iam::<your_account_number>:role/<your_role_name>' manifest;
copy warehouse from 's3://yourbucketname/manifest/tpcdswarehouse.manifest' iam_role 'arn:aws:iam::<your_account_number>:role/<your_role_name>' manifest;
copy web_page from 's3://yourbucketname/manifest/tpcdswebpage.manifest' iam_role 'arn:aws:iam::<your_account_number>:role/<your_role_name>' manifest;
copy web_returns from 's3://yourbucketname/manifest/tpcdswebreturns.manifest' iam_role 'arn:aws:iam::<your_account_number>:role/<your_role_name>' manifest;
copy web_sales from 's3://yourbucketname/manifest/tpcdswebsales.manifest' iam_role 'arn:aws:iam::<your_account_number>:role/<your_role_name>' manifest;