Top "Amazon-redshift" questions

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

How to add a sort key to an existing table in AWS Redshift

In AWS Redshift, I want to add a sort key to a table that is already created. Is there any …

amazon-redshift
How to unload a table on RedShift to a single CSV file?

I want to migrate a table from Amazon RedShift to MySQL, but using "unload" will generate multiple data files which …

mysql amazon-web-services amazon-redshift
Invalid digits on Redshift

I'm trying to load some data from stage to relational environment and something is happening I can't figure out. I'm …

sql database amazon-redshift
Unloading from redshift to s3 with headers

I already know how to unload a file from redshift into s3 as one file. I need to know how …

amazon-redshift
difference between amazon s3 and Amazon redshift

I am studying first time about Amazon Web Services. I want to know what is the difference or relation between …

amazon-web-services amazon-s3 amazon-redshift
Using sql function generate_series() in redshift

I'd like to use the generate series function in redshift, but have not been successful. The redshift documentation says it's …

sql amazon-redshift generate-series
SQL workbench Error while connecting to Redshift

I am trying to create a table in aws redshift using sqlwork bench. I am able to connect redshift but …

postgresql amazon-web-services amazon-redshift
Redshift query between date

I'm quite new to Redshift SQL. select * from myredshift_tbl where local_date between \'2016-01-01\' and \'2017…

sql amazon-redshift
How to Load Data into Amazon Redshift via Python Boto3?

In Amazon Redshift's Getting Started Guide, data is pulled from Amazon S3 and loaded into an Amazon Redshift Cluster utilizing …

python amazon-web-services amazon-s3 amazon-redshift boto3
Pivot for redshift database

I know this question has been asked before but any of the answers were not able to help me to …

sql pivot amazon-redshift