Top "Amazon-redshift" questions

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

skip bad record in redshift data load

I am trying to load data into AWS redshift using following command copy venue from 's3://mybucket/venue' credentials 'aws_…

sql database amazon-redshift
Redshift - How to remove NOT NULL constraint?

Since Redshift does not support ALTER COLUMN, I would like to know if it's possible to remove the NOT NULL …

sql amazon-redshift
S3 -> Redshift cannot handle UTF8

We have a file in S3 that is loaded in to Redshift via the COPY command. The import is failing …

amazon-s3 amazon-redshift paraccel
Is there any way to find table creation date in redshift?

I am having trouble with finding table creation date in Amazon Redshift. I know svv_table_info will give all …

amazon-redshift
How to connect to aws Redshift db from mac

I am using a mac and I typically use Sequel Pro to interact with sql databases. Usually I use mysql, …

macos postgresql amazon-web-services amazon-redshift sequelpro
Redshift Divide By Zero Puzzler

I was getting a divide by 0 error with this code: CASE WHEN DENOMINATOR >= 0 THEN SUM(INT1 * INT2 / DENOMINATOR) ELSE 0 …

sql amazon-redshift vertica divide-by-zero
Redshift division result does not include decimals

I'm trying to do something really quite basic to calculate a kind of percentage between two columns in Redshift. However, …

sql amazon-redshift
How to pipe data from AWS Postgres RDS to S3 (then Redshift)?

I'm using AWS data pipeline service to pipe data from a RDS MySql database to s3 and then on to …

postgresql amazon-web-services amazon-redshift amazon-data-pipeline
AWS Glue: How to handle nested JSON with varying schemas

Objective: We're hoping to use the AWS Glue Data Catalog to create a single table for JSON data residing in …

amazon-redshift aws-glue amazon-dynamodb-streams amazon-redshift-spectrum
How to safely unload/copy a table in RedShift?

In RedShift, it is convenient to use unload/copy to move data to S3 and load back to redshift, but …

amazon-redshift