menu

Advanced Amazon Redshift: Data Loading

Ir al Laboratorio

571 Opiniones

0b20f0867e22cd2083c9834f5acf0fb9

****

S U. · Revisado hace alrededor de 2 meses

81c3fb3f9c69e97258b6878dd66d7d8a

Not a practical use for large enterprises with ETL tools, but might come in handy for one-off simi-structured data

David L. · Revisado hace alrededor de 2 meses

4bc8ca6d2635ae413ee8802e4a9535a3

there was an error on the table without encoding, showed different results on the lab than in the actual product (lzo vs none on encoding). no worries, good lab

David M. · Revisado hace alrededor de 2 meses

5bee3dfc21c4f4729037742b34dbaa55

Subhajit B. · Revisado hace alrededor de 2 meses

272d1bd87b6362725f953ec95f737eb0

Chris S. · Revisado hace alrededor de 2 meses

F9a60e645795f03a80d6f31c3a8a43f5

Hong Z. · Revisado hace alrededor de 2 meses

Eda7687a2fb059c4d5b9c6d5beb8d2db

scott s. · Revisado hace alrededor de 2 meses

8b116f47b6a7003799c9ff92f1f50cc0

Laxman s. · Revisado hace alrededor de 2 meses

2a6f6177baa5fb7622f681ad644b4ed4

Amir T. · Revisado hace alrededor de 2 meses

Bdbe495b6337b10f52878ae9574831b3

yongseong l. · Revisado hace alrededor de 2 meses

E71bbfaac02dbe17835ad9806e733c00

Jeroen M. · Revisado hace alrededor de 2 meses

A51a9b5e8d6b36f86350e9fdc2d1ddd0

芝崎 亮. · Revisado hace alrededor de 2 meses

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. · Revisado hace 2 meses

877d4dcc84ccaaa30e9e9c72193ac67b

Maria S. · Revisado hace 2 meses

13f437dbf565f392e6e9c7567a53d51b

Brian W. · Revisado hace 2 meses

884ba8cf14deb893e44e5679932a6437

Data Pipeline did not work

Chad D. · Revisado hace 2 meses

9a4074810c5d03b4bb495f8e79d31365

Steve C. · Revisado hace 2 meses

D3b05f9c9f031c069cefc3639403c8e1

IAM Errors prevents me from Finishing this lab.

Daniel H. · Revisado hace 2 meses

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. · Revisado hace 2 meses

80bb07e079d0dad0933f854051d01461

rachel b. · Revisado hace 3 meses

293a304306f066cd708235d3bc9d961b

Saurabh S. · Revisado hace 3 meses

Ee0a0d9903abf5eccd61159c5aff22e5

Steven P. · Revisado hace 3 meses

Bede32676aafcf5932357a486a53a077

Eugene V. · Revisado hace 3 meses

A0c6585ad5ccc6c60d03d481afc2caf8

Nicholas B. · Revisado hace 3 meses

240cd197baca0b8d19120302ed802203

Tong W. · Revisado hace 3 meses