Skip to main content

pandas extension for AWS RedShift (Not Officail library)

Project description

# pandas-rs

Pandas extension for AWS RedShift (not official)
inspired by [pandas-td](https://github.com/treasure-data/pandas-td)

# installation

~~~
pip install pandas-rs
~~~


# Usage

First export password via shell(recommended)

~~~shell
export REDSHIFT_PASSWORD='password'
~~~

~~~py
import pandas_rs as rs
import os # use only if you will access password through environment variables

rs.create_engine(
dbname='dev',
user='test',
password=os.environ['REDSHIFT_PASSWORD'],
host='foobar.redshift.exmple',
port='5439'
)


print(rs.read_sql("""select 'hello redshift' greeting"""))
~~~

result

~~~py
greeting
0 hello redshift
~~~

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

pandas-rs-0.1.3.tar.gz (2.5 kB view hashes)

Uploaded source

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page