All Content 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
1040 results
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...
EXPERT
published 3 months ago0 votes988 views
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...
I am trying to use the DATEADD function, but I encountered an issue. I am querying an S3 database using Athena. Do I need to store the data in Redshift to use the DATEADD function? Any guidance would...