Top "Amazon-redshift" questions

Amazon Redshift is a petabyte-scale data warehousing service using existing business intelligence tools to analyze the data.

Copying data from S3 to AWS redshift using python and psycopg2

I'm having issues executing the copy command to load data from S3 to Amazon's Redshift from python. I have the …

python psycopg2 amazon-redshift
NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:redshift.psycopg2

I am trying to connect to redshift from my python code. my pip installed: psycopg2==2.6.1 redshift-sqlalchemy==0.4.1 SQLAlchemy==1.0.9 and my virtual …

python-2.7 sqlalchemy vagrant amazon-redshift vagrantfile
How to measure table space on disk in RedShift / ParAccel

I have a table in RedShift. How can I see how many disk-space it uses?

amazon-web-services amazon-redshift paraccel
How to change table schema after created in Redshift?

Postgre supports this operation as below: ALTER TABLE name SET SCHEMA new_schema The operation won't work in Redshift. Is …

amazon-redshift
Redshift table update with join

I have 3 table t1, t2 and t3. t1 has 2 column-> id1, val1 t2 -> id2, val2 t3 -&…

postgresql join amazon-redshift
Defining a Redshift connection in DataGrip

I'm trying to define a Redshift connection in DataGrip but couldn't find any Redshift driver in the UI. I tried …

jdbc amazon-redshift datagrip
Copying a table from one redshift cluster to another redshift cluster(without using s3)

Can we directly copy a table from one redshift cluster to another redshift cluster? I know table copying can be …

amazon-redshift
Time Difference in Redshift

how to get exact time Difference between two column eg: col1 date is 2014-09-21 02:00:00 col2 date is 2014-09-22 01:00:00 …

sql amazon-redshift date-arithmetic
Amazon Redshift : drop table if exists

Does Redshift support any statement equivalent to the following? DROP TABLE IF EXISTS tablename

amazon-redshift