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

15 votes368 views6 answers
Django install
Python Django
22 votes317 views4 answers
How to create a string in python
Python
0 vote375 views1 answer
Backend not found Request Method: GET Request URL: http://127.0.0.1:8000/oauth/login/google-oauth2/ Raised by: social_django.views.au
Python Django
0 vote324 views1 answer
Python program using for for the fibonacci number
Python
0 vote317 views1 answer
Python find matching string regardless of case
Python
25 votes486 views2 answers
Start new app in django
Python Django
0 vote343 views1 answer
Randian angle to degrees using numpy
Python
1 vote332 views1 answer
Python docker api example
Python
0 vote331 views1 answer
Python append filename to path
Python
6 votes312 views3 answers
How to get all links text from a website python beautifulsoup
Python