Stack Overflow
Stack Overflow

Questions tagged [aws-redshift]

7 questions
15
votes
1 answer

How to assign table ownership to multiple users or group in Redshift

I was wondering if there is a way how to assign table owner to a group or to multiple users in Redshift? If not, is there any workaround you use to solve this need? Thanks for any tips.
Jakub Dvorak
  • 163
  • 1
  • 1
  • 5
2
votes
5 answers

is there is a way to automate the redshift vaccum process through udf?

I have more that 300+ table in redshift. Data is getting update daily basic just want to know can i create a udf in redshift to automate the vaccum process. I found a link automate using python but not that great python coder i am so looking for…
diptiranjan pradhan
  • 81
  • 3
  • 12
2
votes
3 answers

Copy data from DynamoDB into Redshift across two different AWS accounts?

For reasons beyond my control, I have the following: A table CustomerPhoneNumber in DynamoDB under one AWS account. A Redshift cluster under a different AWS account (same geographic region; EU) Is there any way to run the COPY command to move data…
Ray
  • 3,137
  • 8
  • 32
  • 59
1
vote
2 answers

How to execute Redshift queries in parallel

I need to simulate some basic load testing against my Redshift cluster and I need to execute around 20 SELECT queries in parallel. Since stored procedures are not supported by Redshift, I would love to get some ideas on how I can accomplish this.
Raj
  • 549
  • 2
  • 11
  • 25
0
votes
2 answers

Converting String to Decimal Redshift SQL

I have this redshift SQL query. I extracted a number with decimal from the comment using the "REGEXP_SUBSTR" function. I also need to convert it from string to number/decimal. Then, I need to subtract that number from the total. This is my query…
Almo Ubuy
  • 1
  • 2
  • 5
0
votes
1 answer

AWS DMS: Data not getting replicated to AWS Redshift

My source DB is AWS RDS and my target table is AWS Redshift. The data is loaded successfully but after that changes are not pushed to the target DB and there are no exceptions. Configuration: Migration type: Full Load, Ongoing Replication Source DB:…
JDev
  • 1,662
  • 4
  • 25
  • 55
0
votes
1 answer

Data Copy from s3 to Redshift: Manifest is in different bucket than files I need to download

I am trying to copy data from a large number of files in s3 over to Redshift. I have read-only access to the s3 bucket which contains these files. In order to COPY them efficiently, I created a manifest file that contains the links to each of the…
Moe Chughtai
  • 384
  • 2
  • 13