menu

Advanced Amazon Redshift: Data Loading

Go to Lab

534 Reviews

F634423be88cf3adbd0c3a9e6b01b4b5

cannot run pipeline part at all. error - Data Pipeline failed to create pipeline : User: arn:aws:sts::661672926503:federated-user/annie is not authorized to perform: iam:PassRole on resource: arn:aws:iam::661672926503:role/qls-1936551-ab96b35e55228b52-RootInstanceProfile-1VQV6CG3EY2DA (Service: DataPipeline; Status Code: 400; Error Code: AccessDeniedException; Request ID: 58df3a79-cfa4-11e7-bd66-b5a16a17c995) (Service: null; Status Code: 0; Error Code: null; Request ID: null)

Annie D. · Reviewed 19 days ago

877d4dcc84ccaaa30e9e9c72193ac67b

Maria S. · Reviewed 21 days ago

13f437dbf565f392e6e9c7567a53d51b

Brian W. · Reviewed 24 days ago

884ba8cf14deb893e44e5679932a6437

Data Pipeline did not work

Chad D. · Reviewed 24 days ago

9a4074810c5d03b4bb495f8e79d31365

Steve C. · Reviewed 24 days ago

D3b05f9c9f031c069cefc3639403c8e1

IAM Errors prevents me from Finishing this lab.

Daniel H. · Reviewed 28 days ago

494345a2dc441eea26d5437ae93bdd10

Lots of inaccuracies in the steps. For example, encoding shows LZO by default wheras your demo show "none" redshiftdemo=# select "column", type, encoding from pg_table_def where tablename = 'supplier'; column | type | encoding -------------+------------------------+---------- s_suppkey | integer | lzo s_name | character(25) | lzo s_address | character varying(40) | lzo s_nationkey | integer | lzo s_phone | character(15) | lzo s_acctbal | numeric(12,2) | lzo s_comment | character varying(101) | lzo (7 rows) redshiftdemo=# select "column", type, encoding from pg_table_def where tablename = 'customer'; column | type | encoding --------------+------------------------+---------- c_custkey | bigint | lzo c_name | character varying(25) | lzo c_address | character varying(40) | lzo c_nationkey | integer | lzo c_phone | character(15) | lzo c_acctbal | numeric(12,2) | lzo c_mktsegment | character(10) | lzo c_comment | character varying(117) | lzo (8 rows) redshiftdemo=# Also, pipeline creation failed with the following error: Data Pipeline failed to create pipeline : User: arn:aws:sts::676252852787:federated-user/gslongani is not authorized to perform: iam:PassRole on resource: arn:aws:iam::676252852787:role/qls-1905514-8ee7de4fe0740fc1-RootInstanceProfile-1KBFZ3FN351KH (Service: DataPipeline; Status Code: 400; Error Code: AccessDeniedException; Request ID: eb0f9374-c5d2-11e7-b348-d5f3f855afd3) (Service: null; Status Code: 0; Error Code: null; Request ID: null)

pauly l. · Reviewed about 1 month ago

80bb07e079d0dad0933f854051d01461

rachel b. · Reviewed about 1 month ago

293a304306f066cd708235d3bc9d961b

Saurabh S. · Reviewed about 1 month ago

Ee0a0d9903abf5eccd61159c5aff22e5

Steven P. · Reviewed about 1 month ago

Bede32676aafcf5932357a486a53a077

Eugene V. · Reviewed about 1 month ago

A0c6585ad5ccc6c60d03d481afc2caf8

Nicholas B. · Reviewed about 1 month ago

240cd197baca0b8d19120302ed802203

Tong W. · Reviewed about 1 month ago

1bebce8afb23719033c4368b42128ed0

As usual, the figures were too small.

Nelson S. · Reviewed about 1 month ago

117572d4974312c1cd8c617880c3cbff

Sharaz K. · Reviewed about 1 month ago

1438ba5d51f744154c6bed88d3b8b8ba

pierre m. · Reviewed about 1 month ago

571c28c5b8028d7bdf2bb8035e35aab2

Guy K. · Reviewed about 1 month ago

Fdf872c9215dab7af4f48d464a6cfa9c

Santosh C. · Reviewed about 1 month ago

7b95cc08400de53d486e75d4f36d0858

seiji j. · Reviewed about 1 month ago

148dbd8da0f5b35ba0f688f73cfda160

Paul S. · Reviewed about 1 month ago

Ef8d01d906faa8b031a1f0397ea1b68e

Jagadeesh P. · Reviewed about 2 months ago

D25a93287020d49720e5b0de59ff86c3

Oscar H. · Reviewed about 2 months ago

8e066b656e68da74d4bd818b54030859

Sivakumar V. · Reviewed about 2 months ago

De93158be8c758926b5557183c90d79d

Due to not proper explanation, I couldn't complete all steps...

Taguchi G. · Reviewed about 2 months ago

6d11ae96affe4c32f5e26f9b5d5eb2de

不懂命令意思

han c. · Reviewed about 2 months ago