I have a scheduled query in Redshift that simply will not run. It works when I execute the query manually in the query editor, just not when scheduled. I can't seem to find any feedback about why i...

When I'm logging queries executed on Amazon Redshift by querying STL_QUERY table, I get the prepared statement query, without the parameters values, for example: SELECT * FROM events WHERE ts=$1 ...

I am having trouble with finding table creation date in Amazon Redshift. I know svv_table_info will give all the info about the table but the creation date.Can anyone help please?

I have created a external table in redshift spectrum.Upon running the select * from table_name, i am getting following error SQL Error [XX000]: ERROR: Spectrum Scan Error Detail: ---------------...

I created a cloudformation stack with redshift cluster and a masteruser: testuser "RedshiftCluster" : { "IamRoles" : [ { "Fn::GetAtt": [ "IAMInstanceRole", "Arn" ] } ] ... other configura...

The following query works in Postgresql but not in Redshift: WITH bar (baz) AS (VALUES ('a'), ('b'), ('c')) SELECT * from bar; Which gives baz --- a b c How can I replicate this behaviour in...

Part One : I tried glue crawler to run on dummy csv loaded in s3 it created a table but when I try view table in athena and query it it shows Zero Records returned. But the demo data of ELB in At...

When I run the first query all runs fine: select uid, (select top 1 city from UserData where UserData.uid = #uids.uid group by city) from #uids; The problem is when I add order by count(city), ...

I thought it is straightforward but I couldn't find a way to list all tables and their creators (or owners) in Redshift. Any help/insight is welcome.

I'd like to use the generate series function in redshift, but have not been successful. The redshift documentation says it's not supported. The following code does work: select * from generate_s...

I'm trying to duplicate a Redshift table including modifiers. I've tried using a CTAS statement and for some reason that fails to copy modifiers like not null create table public.my_table as (sel...

I'm trying add a new field in a redshift table. But I want to add only if this field doesn't exists. I tried wrapping it with IF NOT EXISTS. But I got following error: Amazon](500310) Invalid opera...

The following works in Postgres 9.6 but not in Redshift: ALTER TABLE stats ADD COLUMN IF NOT EXISTS panel_exit timestamp; Can the same functionality be achieved in Redshift?

I am trying to set up unixODBC to access Amazon Redshift and I keep getting this error, I have triple checked my setup but not sure what the issue is > isql -v mlaws [01000][unixODBC][Driver Man...

Let me ask something about column compression on AWS Redshift. Now we're verifying what can be made better performance using appropriate diststyle, sortkeys and column compression. If my understan...

I am trying to delete some duplicate data in my redshift table. Below is my query:- With duplicates As (Select *, ROW_NUMBER() Over (PARTITION by record_indicator Order by record_indicator) as Du...

I've got a django model with a lot of fields. I'm trying in a single query to get the avg value of a given field and the average value of the top 5 values of that same field (from my other question...

I'm doing something among the lines of: conn_string = "postgresql+pg8000://%s:%s@%s:%d/%s" % (db_user, db_pass, host, port, schema) conn = sqlalchemy.engine.create_engine(conn_string,exec...

I've got a redshift table with many columns. Id like to be able in a single query to get the avg value of a given column and the average value of the top 5 values for a given group by clause Here i...

I have the below simple script for AWS Glue. I have a text file with empty cells and a table which accepts NULL values. When I run the glue job it fails with the exception, "Don't know how to save ...

I'm trying to load some text files to Redshift. They are tab delimited, except for after the final row value. That's causing a delimiter not found error. I only see a way to set the field delimiter...

I am trying to connect to my redshift cluster using Sqlalchemy in a linux environment, but i am facing the following issue. from sqlalchemy import create_engine import pandas as pd conn = create_e...

How to alter column data type in Amazon Redshift database? I am not able to alter the column data type in Redshift; is there any way to modify the data type in Amazon Redshift?

While trying out different compression settings in Redshift it would be very useful to know the size of each column. I know how to get the size of a table, but I want to know the size of each indiv...

I've created a serverless Redshift instance, and I'm trying to import a CSV file from an S3 bucket. I've made an IAM role with full Redshift + Redshift serverless access and S3 Read access, and add...