Stay up to date with the latest from the Knowledge Center. See all new Knowledge Center articles published in the last month, and re:Post’s top contributors.
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
Filter content
Select tags to filter
Sort by
Sort by most recent
1218 results
I have an S3 bucket that is populated by csv files from the output of an API run. The problem is that before and after a particular date, my column order is different which is causing the load job to ...
I’m working with AWS DMS to replicate data from **Aurora PostgreSQL (RDS)** to **Amazon Redshift** using **full load + CDC**.
* **Task 1 (Single-Tenant Schema):**
Replicates from one schema only. N...
We create the following operator on our redshift cluster:
CREATE OPERATOR public.&& (
LEFTARG = GEOMETRY,
RIGHTARG = GEOMETRY,
PROCEDURE = ST_Intersects
);
The operato...
I have an Aurora RDS Postgres cluster running 17.4. I've enabled ZeroETL to our Redshift cluster.
The Redshift Cluster is in another AWS account but both are in the us-west-2 region.
I've enabled ...
Cluster info
• Node type & count: 4 nodes (ra3.xlplus)
• Redshift version: 1.0.121010 (patch 193)
Problem summary
After scaling the cluster from 2 to 3 and later 4 nodes we observed that the new n...
Does zero-ETL for DynamoDB capture all changes to a record? We have history mode enabled, but noticed that not all changes are synced to Redshift. We found that if multiple changes happen within 1 or ...
I'm experiencing an issue with AWS Schema Conversion Tool (SCT) where the connection to Redshift fails when using CLI mode, but works perfectly fine with the same parameters in the UI interface.
Envi...
asked 19 days ago
I have a data repository in JSON that includes an attribute called "timestamp" (which is a reserved word). This attribute is part of a nested JSON/struct.
The way I query the data is by creating a Gl...
How can i check what settings have been used when creating a zeroETL database in redshift
e.g Setting for TRUNCATECOLUMNS and QUERY_ALL_STATES
Is there a view I can reference, did check pg_databas...
Hi
Since support for Redshift "Exclude" Command was added recently in patch 188 ([https://docs.aws.amazon.com/redshift/latest/mgmt/cluster-versions.html#cluster-version-188]()).
I was using the `Excl...
I have been querying data in Redshift with no issues for a few months and starting yesterday, whenever I click into a new query, Query Editor V2 shuts down and the page goes dark. Is this happening to...
there is one postgreSQL table ,and the table have some column is JSONB.
the table sync failed. but the data in PostgreSQL table is is JSONB , how it can be not well format JSON?
the Error message is...