Questions tagged with Amazon Redshift
Amazon Redshift uses SQL to analyze structured and semi-structured data across data warehouses, operational databases, and data lakes, using AWS-designed hardware and machine learning to deliver the best price performance at any scale.
Content language: English
Select up to 5 tags to filter
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
929 results
My redshift is secured under VPC. Iam trying to connect to redshift using dedicated username and password created for redshift tables used in power BI. I can unblock my IP address in security...
I'm currently working with the UNLOAD command and need some help with formatting the output CSV file. Specifically, I want to achieve the following:
Empty strings should be quoted values: ,"",
NULL...
I have been trying to send data from Salesforce to Redshift using App Flow. Every time when I setup the flow I am getting an error 'Connector timed out'. I have tried both serverless and cluster. I...
Hi Team,
We are using Redshift Cluster with the following configurations
* **Node type: dc2.large**
* **Number of nodes: 4**
* **Storage Usage Details : 65.13% (416.84 of 640 GB used)**
While...
Hi! I'm running an UNLOAD from Athena, and then a COPY to Redshift, I'm having an issue about how the SUPER fields are loaded into Redshift
```
UNLOAD (
SELECT
curpVerification AS...
**Use Case:**
Build a data warehouse in Redshift using DynamoDB data.
**Background:**
I am creating 6 different Redshift tables from a single DynamoDB table using glue visual ETL. There are 6...
I am using public subnet, that has a route table with internet gateway, destination 0.0.0.0/0. I am still not able to access to pypi to download necessary libraries in glue python shell. Getting below...
Hi,
I wanted to know what will be the cost to execute.
MSCK REPAIR TABLE tablename
Also if there is any other way to refresh / load partitions to athena table which is better than *MSCK REPAIR *...
Our redshift cluster was recently upgraded to 1.0.69065 and we instantly noticed decreased performance for large queries. After investigating and determining no other changes were made we rolled back...
we need stronger SQL passwords for our Redshift users.Any way to force stronger password policy?Like min length etc.
asked 4 months ago
I have 2 different Redshift clusters. Each cluster have a PostgreSQL database with the same schema.
I want to do a federated query across these 2 databases in the 2 different Redshift clusters.
Is...
asked 4 months ago
I am using some syetem tables like svv_roles, svv_user_grants, svv_role_grants, SVV_ALL_SCHEMAS, SVV_SCHEMA_PRIVILEGES, etc. But as a regular user I am not able to see all the content which superuser...