Amazon RedshiftGetting Started GuideAPI Version 2012-12-01 - PDF document

© 4 (c. .)4 (c. .)*.fficis ....ii .*.....3.phddi .D.s ahiW(.Usir  hddi ahis hddi . . is ahi p2ii.4 dr ahi ,Oiaids .4.y5v y rppuyhddi g355 rppuy. Lhis hddi ahi Rs sOy5ir d Npyuphddi + dc2.iarge Tiah Npyu+ 2 dr ahi aOadriRx.(.s ahi DiRibiuy diy (pvRepdi5) DiRibiuy MiuRy huy diy Rs . Lhi aOadriRx Oi ahii RxOi+4DiRibiuy diy (pvRepdi5)+ 5sair dev.4+ 5sair 5.4MiuRy huy diy+ 5sair asuser.4k.5huRy vyeuuepdumyRedshiRhie. Lhis hddi .B.Uuy y2ih5Ru   MpdeRpeds Rs BikhvP.phddi yiRy 5huRy.*.. isahi .... 3.Qhek 5ihdr 5huRy. D D.ffis ahi 5huRy uvye+iRepduLihdr 5huRy+4+ phddi 25isy.42.45huRy eydRe+y+ 5sair ahi RxOi .4MiuRy huy diy.4 Rs 45437.4+ phddi .y. ( NpRy.(.ahi xia d xOair. k.ffis ahi 5huRyu5huRy hRiRhu5huRy hRiRhu i Rs ahi DiRibiuy .yi5Rr i k B.ffis ahi 5huRyu5huRy. phddi ahi NpRy dr ahi Oesedi5*. B ..*.5huRyu...phddi eampieciuserpd+shiRepd aR5.3.Usir  dr D.gdbphd aR5. (.phddi  +4+ .4+ .4myRe4huRp ahis isair dsdsdsdhd. P *....phddi Uuyu.3.D.phddi i vyeuuepdu.(.phddi .k. hddi Rs .B.phddi .P.phddi i vyeuuepdu.4444NpRy dr ahi Oesedi5*....ffis ahi 45huRy+ phddi eampieciuser4DiRibiuy diy+ 5sair dev4DiRibiuy huy+ 5sair asuser4+ 5sair passhrd ha yhu speciied he yhu creaed heciuserLhis hddi .3.hryi hddi vhb5e D.chd .pgp gbp uripuN uripgxp P.r N3dOT .ii P.rN3dOOw *g (.phddi .k.chd 2upg 2gi uripu P5pu NLi.puLT LbiULOTNLucuLT Lb.*LOwB.phddi .P.chd upp.g + .i uripuw Lhi RsRx 5xR3 xdRir F.phddi ad iiT ahi rOs iaRix.*g.phddi *.....3.s ahi yydRei5u+45huRy+ phddi .4DiRibiuy+ y.4DiRibiuy huy+ 4D.hryi hddi vhb5e ** ,Oirii444 (c. F)4 (c. *.)4444444444iiadr is ahi ihiapcur2.gv5pc2gi Rs ihiapcur2.gapci..puuihiapcur2.gv5pc2gi Rs ihiapcur2.gapci..puu F (. .pgp gbp uripuNuripgxp P.r N3dOT.ii P.rN3dOOwk.phddi .B.aR5xi. 2upg 2gi uripu P5pu NLi.puLT LbiULOTNLucuLT Lb.*LOwP.phddi .F.aR5xi. upp.g + .i uripuw 4 (c. *3)4 (c. *3) *. D.phddi *.5huRyu...phddi eampieciuserpd+shiRepd aR5.3.ffis ahi pd+shiRepd aR5 Osir NpRyaRai. *...phddi  Rs ahis hddi .3.phddi .D.(.phddi . Lhi k.phddi Niy *D ahis hddi Ovyd.  ahi dr Rs ahis hddi OK5iuudiy 5xRs3 Rs hddi OK.B.P.UcLF.Uuydiy isair asuser*g.**.phddi .*..phddi ahi *( k.ffis ahi cR2i hddi . Lhis hddi .B.Lhi i Risu.P.myRedshiRhie.F..*g.**.aic k+ (c. *k).NpRy dr ahi Oesedi5*.. is ahi...3.LUhT*ch ahis hddi yiRy 5huRy. Lhi yiRy 5huRy cR2iRcciRr.D.s ahi 5huRy eydRe+y  Rs Npyu.45huRy eydRe+y+ 5sair eampieciuser dr ahi aOadriRx. Lhi iisai.ir yOa 5i Osi,Oi. Lhi4NpRy 3 aic k+ MdR Rycxi RaR *.cpP is ahi . .pgp gbp 5upuN 5up2c 2gp,p ig 5 c2ug*p uig*pT 5upp .rN-OT .2ugp P.rNRdOT ugp P.rNRdOT .2g P.rNRdOT uggp .rN.OT p2 P.rN3ddOT xrip .rN3yOT 2*puxigu biipT 2*pgrpgp biipT 2*p.i.pgu biipT 2*p3hh biipT 2*p.uu2. biipT 2*pixp biipT 2*pi.* biipT 2*pPp,u biipT 2*pbicU biipT 2*p5u2.u biipOw .pgp gbp Pp5pN Pp5p2c u2g ig 5 c2ug*p uig*pT Pp5pp P.rN3ddOT Pp5p.2g P.rNRdOT Pp5puggp .rN.OT Pp5pupgu 2gp,pOw .pgp gbp .gp,iN .g2c u2g ig 5 c2ug*p uig*pT .g,i5x P.rN3dOT .gp P.rN3dOT .gcpu. P.rNmdOOw .pgp gbp cgpN cgp2c u2g ig 5 c2ug*p uig*pT .cgp cgp ig 5T c .r.gpNRO ig 5T Upp* u2g ig 5T igr .r.gpNmO ig 5T Dg .r.gpNmO ig 5T p u2g ig 5T ri2c biip cp.5gNL(LOOw .pgp gbp pPpgN pPpg2c 2gp,p ig 5 c2ug*pT Pp5p2c u2g ig 5T .g2c u2g ig 5T cgp2c u2g ig 5 uig*pT pPpgp P.rN.ddOT uggg2p g2pugxOw *B aic k+ MdR Rycxi RaR .pgp gbp 2ug2,N 2ug2c 2gp,p ig 5 c2ug*pT upp2c 2gp,p ig 5T pPpg2c 2gp,p ig 5T cgp2c u2g ig 5 uig*pT 5g2.*pgu u2g ig 5T x2.pxpg2.*pg cp.2N-T.OT gigx2.p cp.2N-T.OT 2ugg2p g2pugxOw .pgp gbp upuN upu2c 2gp,p ig 5T 2ug2c 2gp,p ig 5 c2ug*pT upp2c 2gp,p ig 5T b5p2c 2gp,p ig 5T pPpg2c 2gp,p ig 5T cgp2c u2g ig 5 uig*pT Dguic u2g ig 5T x2.px2c cp.2N-T.OT .i2uu2i cp.2N-T.OT upg2p g2pugxOw..NpRy is ahi.ai3ia5.eic.xi ad R g2.*2g is ahi myReds uiy3gi uadrRci.ROahisaiRaids ii ph5-5JLmM is ahi NpRy)R)pP2.pM.pxg2ik i..puu Bp2pc. is ahi myReds. .ix 5upu .i LuRkhh-myRedshihg2.*2gh5upuQx2xpsgMgL .pcpg2u LUuQ2Qip2-hmiaphihcL cp22gp L5L p,2i L-hurih2acLw-hmiaphihcWis ahi ph5-5JLmM cRrRyiair (c. .). *P aic k+ MdR Rycxi RaR .ix 5upu .i LuRkhh-myRedshihg2.*2gh5upuQx2xpsgMgL .pcpg2u LUuQ2Qip2kUuk2kk3.Rym47-ed3.kiphapcur2.gaipL cp22gp L5L p,2i L-hurih2acLw-myRedshi -hmiaphihc Rs -hurih2ac is ahi .ix 5upu .i LuRkhh-myRedshihg2.*2gh5upuQx2xpsgMgL .pcpg2u LUuQ2Qip2-hmiaphihcL cp22gp L5L p,2i L-hurih2acLw .ix Pp5p .i LuRkhh-myRedshihg2.*2ghPp5pQx2xpsgMgL .pcpg2u LUuQ2Qip2-hmiaphihcL cp22gp L5L p,2i L-hurih2acLw .ix .gp,i .i LuRkhh-myRedshihg2.*2gh.gp,iQx2xpsgMgL .pcpg2u LUuQ2Qip2-hmiaphihcL cp22gp L5L p,2i L-hurih2acLw .ix cgp .i LuRkhh-myRedshihg2.*2ghcgp.dd-Qx2xpsgMgL .pcpg2u LUuQ2Qip2-hmiaphihcL cp22gp L5L p,2i L-hurih2acLw .ix pPpg .i LuRkhh-myRedshihg2.*2ghpPpguQx2xpsgMgL .pcpg2u LUuQ2Qip2-hmiaphihcL cp22gp L5L g2p.ig L((((-))-BB HHk)Ik))L p,2i L-hurih2acLw .ix 2ug2, .i LuRkhh-myRedshihg2.*2gh2ug2,uQx2xpsgMgL .pcpg2u LUuQ2Qip2-hmiaphihcL cp22gp L5L p,2i L-hurih2acLw .ix upu .i LuRkhh-myRedshihg2.*2ghupuQgbsgMgL.pcpg2u LUuQ2Qip2-hmiaphihcLcp22gp L?gL g2p.ig L))hBBh(((( HHk)Ik))L p,2i L-hurih2acLw3. is ahi p2ii. -- Kpg cp.22g2i .i grp upu gbps)ffi,0 + Fa) x,QgbpQcp. WHa gbpp 2 LupuLw -- F2c gig upu i  ,2Pp .pc cgps)ffi,0 u5NDguicO Fa) upuT cgp WHa upuscgp2c 2 cgpscgp2c i(B .cgp 2 L.dd--d3-dmLw-- F2c gix 3d b5pu b D5g2gs)ffi,0 .2ugpT ugpT gigQD5g2g *F Fa) N)ffi,0 b5p2cT u5NDguicO gigQD5g2g Fa) upu KaUP B( b5p2c aBa B( gigQD5g2g cpu. 22g 3dO vT 5upuWHa vsb5p2c 2 5up2caBa B( vsgigQD5g2g cpu.w-- F2c pPpgu 2 grp eese xp.pg2p 2 gpu i.  g2p ,iuu upus)ffi,0 pPpgpT gigQx2.p Fa) N)ffi,0 pPpg2cT gigQx2.pT g2pN3dddO iPpNicp b gigQx2.p cpu.O u xp.pg2p Fa) N)ffi,0 pPpg2cT u5Nx2.px2cO gigQx2.p Fa) upu KaUP B( pPpg2cOO vT pPpg  WHa vspPpg2c 2 spPpg2c i(B xp.pg2p 2 3aBa B( gigQx2.p cpu.w5d2 .dsais2i ad i .hRrci dr 5d2r .g2air R gdsc R ia i r2ssisc44+ Lhi 2Oii 5Oix Ocds ahi ydsiadris2 xOair.4+ Lhi 2Oii 5Oix Ocds ahi NpRy dr ahi Oesedi5. .g sdi.g2air. 5Rh xOair rOs Rs444 (ahi c2ii4 (c. *)4 (c. .)4 (c. 3)4 (c. B)4 (c. F)4 (c. *k)4 (c. .g) (c. .g)criis2 isdryRaids 2d ad -iOids drOy. (c. .g) * 4 (c. *D)is (c. *k) (c. .g). is ahi myRedsNpRy*....wd ad ahi uaiy.3.wd ad ahi D.wd ad pds.2Oris2.NpRy dr ahi Oesedi5*....LUhT*chiaRix.3.phddi ahi ad ii ahi RxOi dr Rs *3 aic k+ MdR Rycxi RaR *3.phddi OK. *D. ahi aR5xi. .pgp gbp uripuNuripgxp P.r N3dOT.ii P.rN3dOOw*(. 2upg 2gi uripu P5pu NLi.puLT LbiULOTNLucuLT Lb.*LOw*k. upp.g + .i uripuw cpPNpRy (c. .g). *k *.5huRyu...phddi eampieciuserpd+shiRepd aR5.3.s ahi 5huRy yisO hddi . D.s ahi yiRy udivurpR hddi Np Rs ahis hddi . (.5huRy hRiRhu .. *....LUhT*ch3.phddi ahi eampieciuser hddi . Lhi cR2i RcciRr.D.pds.ry ahi xOair ad 5i ixiai ahis hddi .ffis ahi xOair xia cR2i ahi xOair aRaO i OcRai R ahi xOair i ixiai.4 (c. .*).4igiai ahi .g2air (c. ..).*.5huRyu...phddi pd+shiRepd aR5.3.Usir D.gdbphd aR5 Rs ahis hddi . (.i55 RiffiiROxa. phddi . .* . ridsy DyuevRepd mO2Oa *g .g*P OOxu .P .g*( OOsi F .g*( -dOyisaRaidsOcRai mcrix 3g .g*( -dOyisaRaidsOcRai -dOyisaRaidsOcRai -dOyisaRaidsOcRai -dOyisaRaidsOcRai JiT 2Oii . .3 ..................................................................................................................................*........................................................................................................*.............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................3...................................................................................................B.....................................................................................................F..........................................................................F..............................................................................*.aic k+ MdR Rycxi RaR..........................................................................................................*k.........................................................g..................................................................................................g..............................................................................................................................3 iii