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.
Hey,
We have a Glue crawler crawling a series of CSVs in S3 and capturing this in a database. This is surfaced in Redshift via Spectrum Schema.
The problem we have is that in Redshift, the...
1
answers
0
votes
189
views
asked 6 months agolg...
Hey there,
I have a create table query with sortkey and distkey defined, the source data comes from s3.
The query looks like this
```sql
create table...
1
answers
0
votes
251
views
asked 6 months agolg...
I need to create a aes encryption ECB UDF in the redshift. To achieve this, i have imported pycryptodome zip file in the S3 with the name Crypto.zip and create library in the redshift.
When i try to...
1
answers
0
votes
276
views
asked 6 months agolg...
Scenario:
Source table: Glue Data Catalog table **study** crawled from MySQL with columns:
* id (int),
* code (varchar),
* desc (varchar)
* and 2 other columns not used in the job.
Target table:...
0
answers
0
votes
101
views
asked 6 months agolg...
If my environment is full of Apache Hudi integrating with EMR and Lake Formation, I found out that Hudi environment is not very friendly to be used by Redshift nor Athena. There are many advanced...
1
answers
0
votes
478
views
asked 6 months agolg...
i'm used AWS glue crawler data from S3 Bucket to Datacata log and using AWS redshift query but show error:
ERROR: Parsed manifest is not a valid JSON object. Detail:...
1
answers
0
votes
457
views
asked 6 months agolg...
Hello,
Here is my current situation where I need some help ;)
* I created user groups in Azure Active Directory and added users to it
* I connected AAD with AWS
* I have a redshift database with...
2
answers
0
votes
331
views
asked 6 months agolg...
On `Redshift 1.0.60353`, I'm getting the following error for a query that previously worked:
```
SQL Error [XX000]: ERROR: failed to find conversion function from "unknown" to numeric
```
According to...
1
answers
0
votes
1684
views
asked 7 months agolg...
I have a Redshift cluster currently configured with two ra3.xlplus nodes. I am going to vertical upscale the cluster from two ra3.xlplus nodes to three ra3.xlplus nodes. A planning assumption is that...
1
answers
0
votes
275
views
asked 7 months agolg...
[updated]
Resolved with this...
1
answers
0
votes
409
views
asked 7 months agolg...
when we drop some table in a store procedure, redshift throw below error. After struggling searching on the internet, don't find any. please help. The strange is it only have this issue on dev env, ...
1
answers
0
votes
349
views
asked 7 months agolg...
To connect to Redshift from our app, we would like to replace existing JDBC driver (Java) with the python sql connector if possible. For that purpose, we measured the performance to fetch a few large...
1
answers
0
votes
346
views
asked 7 months agolg...