Рет қаралды 2,522
AWS Redshift connects with Python and Create Cluster using Python jupyter notebook.
Load data from s3 into redshift using python
This video really important for who want to connect with redshift using python boto3 and applied various operation like create cluster, create redshift table and upload data from s3 bucket.
you should have only AWS access key and secrets key and VPC ID and IAM ROLE.
rest of work done by script. you don't need to create cluster manually.
Below topics we covered in this video.
1.create security group for redshift using python
2.create subnet group for redshift using python
3.create redshift cluster using python
4.used pg8000,psycopg2 connect with redshift using python
5.create table in redshift using python
6.load data into table using copy command by python
7.drop table using python
8.delete redshift cluster using python
9.delete security group and subnet group using python
Git link for code
github.com/saurabhgarg013/Pyt...
THANK YOU FOR WATCHING .. PLEASE LIKE SHARE AND SUBSCRIBE
AWS GLUE ETL AND REDSHIFT RELATED DATA ENGINEERING VIDEOS.
• Create Redshift Cluste... (Create Redshift Cluster and Load Data using Python)
• AWS Glue ETL with Pyth... (AWS Glue ETL with Python shell |Read data from S3 and insert Redshift)(Not using Pyspark with glue)
• AWS GLUE Complete ETL ... (AWS GLUE Complete ETL Project Demo| Load Data from AWS S3 to Amazon RedShift)(Data engineer Project)
• Redshift using Python|... (Redshift using Python| Load and insert and copy data into redshift using psycopg2 )
• Aws Redshift tutorial ... (Aws Redshift tutorial |Amazon Redshift Architecture | Data Warehouse Concept)
• Building ETL Pipeline ... (Building ETL Pipeline using AWS Glue and Step Functions)
• AWS GLUE CRAWLER TUTOR... (AWS GLUE CRAWLER TUTORIAL with DEMO| Learn AWS GLUE)
• AWS GLUE CONCEPT|GLUE ... (AWS GLUE CONCEPT|GLUE DATA CATALOG|GLUE TUTORIAL)
In case of any query, you can contact us directly on WhatsApp 8800502668
and you can write mail technodevs13@gmail.com