Pyspark read from redshift

from pyspark.sql import SQLContext

sc = # existing SparkContext
sql_context = SQLContext(sc)

# Read data from a table
df = sql_context.read \
    .format("com.databricks.spark.redshift") \
    .option("url", "jdbc:redshift://redshifthost:5439/database?user=username&password=pass") \
    .option("dbtable", "my_table") \
    .option("tempdir", "s3n://path/for/temp/data") \
    .load()

Similar codes

115 votes325 views6 answers
Python user input
Python
2 votes289 views1 answer
List pop method in python
Python
0 vote275 views1 answer
Y=mx+b python
Python
-1 vote247 views1 answer
Heads or tails python
Python
3 votes251 views1 answer
Visual studio code import library python
Python
0 vote272 views1 answer
Procfile for django heroku
Python Django
0 vote241 views1 answer
Recursive Folder scan
Python
2 votes269 views1 answer
Sacar la posicion en una lista python
Python
1 vote243 views1 answer
Cartesian product of a list python
Python
0 vote273 views1 answer
How to set up pygame
Python