Questions tagged with Amazon Redshift
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.
There is a known bug in json_extract_path_text spelled out at https://stackoverflow.com/a/76303424. Why has it not been fixed?
1
answers
1
votes
223
views
asked 10 months agolg...
IHAC who is building its analytical platform on Redshift. One of their data source is Oracle RDS and they tend to replicate all the data and change of its 900 table to Redshift. The initial design...
1
answers
0
votes
371
views
asked 10 months agolg...
Redshift Serverless Workgroup crashed and now Namespace metrics for are unavailable. How to recover?lg...
We had a very interesting but worrying incident with a staging environment in Redshift Serverless. Upon execution of a stored procedure that used DDL, Redshift Serverless got stuck in an unusable...
1
answers
0
votes
343
views
asked 10 months agolg...
Hi,
I am trying to ran a simplest query on tommy_asin_v2 table, at bumblebee I found that it it belongs to the andes_ext.searchdata catalog:
But when I ran: select * from...
1
answers
0
votes
240
views
asked 10 months agolg...
Hi
We are using datashare to share data between 2 redshift clusters within the same account.
We started running into this started recently, no information regarding this on web or in aws docs.
Any...
1
answers
0
votes
697
views
asked 10 months agolg...
in TD we have -- CAST((CAST(FROM_TIME AS INTEGER) MOD 60) AS FORMAT '99') .
How to achieve the same in Redshift?
thanks
KN
1
answers
0
votes
199
views
asked 10 months agolg...
Hi all, I'm trying to change the subnets assigned to a Redshift Serverless Workspace. I submitted the changes successfully, but it's been a full 24 hours and the workspace is still in the...
1
answers
1
votes
409
views
asked 10 months agolg...
Is there a way in the QuickSight Pivot Table to display rows with no values? Using filler numbers, my organization has 100 unique Regions/Fields, and each active employee is aligned to supporting a...
0
answers
0
votes
94
views
asked a year agolg...
Hi AWS community,
I hope you're all doing well. I have a question regarding data management and best practices when using Amazon Redshift and S3.
Once data has been successfully imported into an...
1
answers
0
votes
437
views
asked a year agolg...
How can I refer item_id column when I create a model of time series forecasting in Redshift ML?
ERROR: One string column type referring to item_id is required for FORECAST [ErrorId:...
1
answers
0
votes
291
views
asked a year agolg...
Hi AWS, if I add `redshift-serverless:*` in the SCP does it change anything i.e.
1. Any public endpoint
2. Lack of support for vpc endpoints
3. Communication flow between AWS Managed service...
1
answers
0
votes
199
views
asked a year agolg...
I've been trying for a few hours to connect to my Redshift serverless database - I'm following steps on this page:
[https://docs.aws.amazon.com/redshift/latest/mgmt/serverless-connecting.html]()
I'm...
1
answers
0
votes
1128
views
asked a year agolg...