I am trying to get the name of the day of a specific date. For example for the date "11/22/2019" I want the result to be "Friday" I use Amazon Redshift. Any ideas? Thanks

The following code connected to Redshift database but returning an empty response even the response will be displayed in the console.log, why? index.js const config = { user: 'user', database: ...

I am not able to connect to the redshift database using Node. I am using Node JS version 14.15.1. Is there any issue related to this version? The following code, I have tried in my local machine, r...

I have a file on S3 called data.csv.gz It is a gzipped CSV. I've successfully ungzipped it with the ungzip command, so I know it's gzipped correctly as far as I can tell. Running the following com...

I have an Amazon Redshift cluster with four schemas (Schema1, Schema2, Schema3 and Schema 4). I created a user User1 in this cluster. I want this user to have only read-only access to all the tabl...

I am trying to set up firehose to send data from a kinesis stream to a redshift cluster. Firehose successfully inserts the data to my s3 bucket, but I am receiving the following error when firehose...

When you load data to your Amazon Redshift tables, you can check the load status using the table STV_LOAD_STATE. I would like to know if there's a way to achieve the same, but with the unload oper...

Is there a query I can run to show currently assigned privileges on a particular schema? i.e. privileges that were assigned like so: GRANT USAGE ON SCHEMA dbo TO MyUser I have tried SELECT * F...

In Amazon Redshift I have a table where I need to load data from multiple CSV files: create table my_table ( id integer, name varchar(50) NULL email varchar(50) NULL, processed_file varchar(25...

Whenever I use ODBC drivers with a full connection string, and not just a DSN entry, I often get an error similar to this Data source name not found and no default driver specified I have the co...

I was unable to drop a redshift db because of a connection: Couldn't drop my_db : #<ActiveRecord::StatementInvalid: PG::ObjectInUse: ERROR: database "my_db" is being accessed by other users I...

I'm trying to migrating some MySQL tables to Amazon Redshift, but met some problems. The steps are simple: 1. Dump the MySQL table to a csv file 2. Upload the csv file to S3 3. Copy the data file ...

As background, I've set up 100's of redshift query's, many much more complex than this and yet I think I must be missing something simple. I am doing a left outer join between Table 1 and Table 2....

How is columnar storage in the context of a NoSQL database like Cassandra different from that in Redshift. If Cassandra is also a columnar storage then why isn't it used for OLAP applications like ...

I have a sample table in redshift. I want to generate a report with the month wise data. I found the below three ways so far. trunc(created_at_date) between '2014-06-01' and '2014-06-30' created_...

I have a CTE that has data like this. It follows two formats pretty much where counts and process_ids will have these two types of data. client_id day counts process_ids ---------------------------...

When I aggregate values in Google Data Studio with a date dimension on a PostgreSQL Connector, I see buggy behaviour. The symptom is that performing COUNT(DISTINCT) returns the same value as COUNT(...

I need to get select data from 2 different tables that they are in 2 different databases. Using SQL Server I would do SELECT * FROM database.schema.table, but I tried that and it didn't work using ...

Here are some bullet points in terms of how I have things setup: I have CSV files uploaded to S3 and a Glue crawler setup to create the table and schema. I have a Glue job setup that writes the da...

Is there a way to add/alter table column encoding on the original table without creating a new table and select all content from old table into new table ?

I am using sql server and we do have a while loop there which I have created in a Stored procedure.. I am evaluating redshift and looking for a equivalent in redshift amazon. Below is what I am try...

I'm currently banging my head against the wall since a few days trying to solve a strange issue happening with the recently released redshift data-api. I'm trying to execute a SQL statement on my R...

I am kind of evaluating Athena & Redshift Spectrum. Both serve the same purpose, Spectrum needs a Redshift cluster in place whereas Athena is pure serverless. Athena uses Presto and Spectrum us...

I am using redshift_connector - Amazon Redshift connector for Python >= 3.5 How to set the schema while running code from python. import redshift_connector # Connects to Redshift cluster using ...

I want to run queries by passing them as string to some supported command of AWS through its CLI. I can see that the commands specific to AWS Redshift mentioned doesnt have anything which says tha...