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.
https://docs.aws.amazon.com/redshift/latest/dg/r_CREATE_EXTERNAL_FUNCTION.html
says "The IMMUTABLE clause isn't currently supported for Lambda UDFs."
But if you use IMMUTABLE it creates the function...
0
answers
0
votes
122
views
asked 7 months agolg...
I am trying to troubleshoot query performance issues and am seeing the following results out of SYS_QUERY_HISTORY.
| query_id | elapsed_time | execution_time | compile_time | planning_time |...
1
answers
0
votes
530
views
asked 7 months agolg...
Loading json files from s3, this runs fine but STORED AS is not marked as optional in the documentation
```
create external table spectrum.mytable(id int, updated_at timestamp)
ROW FORMAT SERDE...
1
answers
0
votes
252
views
asked 7 months agolg...
When I´m about to start an ETL Job, usually I ask some main questions:
1. Where the original file/table is stored?
2. What should I do to delivery data to my end goal?
If I have already all the data...
1
answers
0
votes
459
views
asked 7 months agolg...
Once in a while we seem to get below error in our redshift cluster. It is usually solved by deleting and recreating the affected table. I would however like to understand more in detail why this is...
1
answers
0
votes
263
views
asked 7 months agolg...
Hi, I am trying to get the number of queries executed against Redshift but I found it very difficult to find it for each IAM user in our organization.
The problem is that most of the queries on...
1
answers
0
votes
297
views
asked 7 months agolg...
I've implemented the automatic mounting of the Glue catalog following this process:...
1
answers
0
votes
341
views
asked 7 months agolg...
Hi Team,
I am dumping data from redshift to s3 using unload command, however its splitting the file into 1000+ files. I cannot turn parallel off as it takes 3x the amount of times for the redshift...
1
answers
0
votes
683
views
asked 8 months agolg...
I'm inquiring whether it's possible to access the previous version of the catalog table in the ETL job to examine a specific column's content. Presently, as I'm updating the table from the raw bucket...
1
answers
0
votes
389
views
asked 8 months agolg...
The following query returns 'abcd' instead of an empty result set:
```
WITH
not_in_cte AS (
SELECT *
FROM big_table
WHERE id NOT IN (SELECT * FROM small_table)
),
left_join_cte AS (
SELECT...
Accepted AnswerAmazon Redshift
1
answers
0
votes
422
views
asked 8 months agolg...
Hello,
We have several RDS databases connected to our Redshift cluster using external schemas that have been working well for several months. A few days ago, I updated the certificate authority on our...
1
answers
0
votes
354
views
asked 8 months agolg...
I have created a glue catalog table on top of a dynamo DB table using glue crawler.
I'm trying to read this glue table by creating a external schema in redshift on top of glue database.
Glue...
2
answers
0
votes
363
views
asked 8 months agolg...