Amazon Red Shift for Data Warehouse

[jailokesh]

Hello bro's

anyone using Amazon Red Shift for Data warehousing?

can i get some info how to use this services in ssis or how it performs ETL tasks.

Thanks in adv

[jailokesh]

anyone bhayyas?

 

[Bhai]

Lite.... peddaga bagodu

[jailokesh]

we are planning to use bhayya..

but red shift ah cloud azure ah thinking.

any links to how to do etl with red shift

[GunturGongura]

1 hour ago, jailokesh said:

Hello bro's

anyone using Amazon Red Shift for Data warehousing?

can i get some info how to use this services in ssis or how it performs ETL tasks.

Thanks in adv

you can extract data from redshift using couple of python libraries like psycopg,  once data extract , as an ETL developer u should know further process

 

[Bhai]

[jailokesh]

2 minutes ago, GunturGongura said:

you can extract data from redshift using couple of python libraries like psycopg,  once data extract , as an ETL developer u should know further process

 

any link you can share?

 

[Bhai]

7 minutes ago, jailokesh said:

any link you can share?

 

 

https://www.quora.com/How-do-I-copy-table-data-from-MySQL-to-Redshift-using-Python

 

 

 

You can use the Python libraries psycopg2 & pymysql to connect to mysql and query all data from a table .

What we will do is select all rows from the MySQL table and use the insert command to insert them into Redshift.

[GunturGongura]

13 minutes ago, jailokesh said:

any link you can share?

 

http://sobhan06k.blogspot.com/2014/11/reach-redshift-using-python-library.html

 

hope this example helps u

[Babyy]

1 hour ago, jailokesh said:

Hello bro's

anyone using Amazon Red Shift for Data warehousing?

can i get some info how to use this services in ssis or how it performs ETL tasks.

Thanks in adv

jailokesh 

[Bhai]

16 minutes ago, Babyy said:

jailokesh 

lol @Babyy  @Darling

[GunturGongura]

2 hours ago, jailokesh said:

we are planning to use bhayya..

but red shift ah cloud azure ah thinking.

any links to how to do etl with red shift

redshift 

[ColinKaepernick]

https://www.udemy.com/hands-on-with-amazon-redshift/

https://azure.microsoft.com/en-us/services/sql-data-warehouse/

 

Njoy

[Babyy]

11 hours ago, Bhai said:

lol @Babyy  @Darling

[GunturGongura]

17 hours ago, ColinKaepernick said:

https://www.udemy.com/hands-on-with-amazon-redshift/

https://azure.microsoft.com/en-us/services/sql-data-warehouse/

 

Njoy

Free levu

pay chestene