Questions tagged with Amazon Redshift
Content language: English
Sort by most recent
We have a use case where we need to retrieve data from an external system using a REST API interface and store it into Redshift. The volume of data is expected to be quite small and the process needs to run on a schedule, once a day.
What tools and architecture is recommended for this?
Thanks!
I felt there was a lot of hype around https://aws.amazon.com/about-aws/whats-new/2022/11/amazon-aurora-zero-etl-integration-redshift during the re:Invent and shortly afterward.
However, the announcement says that it is only for the Aurora MySQL certain versions, in the US East (N. Virginia) Region, and only a limited preview. The limited preview link is no longer working.
I am looking for Aurora PostgreSQL zero-ETL integration into Redshift.
Are there any news at all since re:invent? Have I missed anything?
I want to create an IAM role that have permission to unload only one schema in redshift, is it achievable?
some time ago, I was told that for using Kinesis delivery stream to Redshift, you HAD to use a provisioned cluster, not serverless.
Something to do with Kinesis only able to use public IP addresses on both sides, and Redshift serverless was internal-only.
Has this been fixed yet?
I see I can now create a "Redshift endpoint" for Redshift serverless... AND checked the "Enable public access" checkbox.
but when I try to define it as the destination for Kinesis delivery stream (in the GUI), my redshift serverless instance still doesnt show up as an option.
Hello
1. What is difference between Amazon Athena and Amazon Redshift?
2. Which one is the right choice?
3. If we are using RDS, Amazon Athena and Amazon Redshift together in architecture. How does it works together?
4. what is Amazon QuickSight and how does it works ?
Thanks,
Monica
Hi Guys,
After creating views in AWS Redshift SQL code is automatically formatted in a different way.
I am encountering problems while trying to update previously created View. After copying view code and pasting in editor I am getting an error.
Is there any way to convert SQL View Code (automatically formatted) into standard SQL that can be rerun in Editor?
Best regards,
Michal
How can I create a new user in Redshift who has SELECT access to all existing schemas, but has full permissions to create and modify their own schemas?
Hi All, is there anyone tried to configure CloudTrail for Redshift? we are trying to do this to get the IAM user activity who run the query in query editor v2.
We have found few docs and followed the steps to configure the CloudTrail, we cant get the logs we are looking forward.
https://docs.aws.amazon.com/awscloudtrail/latest/userguide/cloudtrail-tutorial.html
https://docs.aws.amazon.com/awscloudtrail/latest/userguide/cloudtrail-create-a-trail-using-the-console-first-time.html
This is the docs we have found to show us CloudTrail can integrate with Redshift. And it can get the log result for the query editor v2.
https://docs.aws.amazon.com/redshift/latest/mgmt/logging-with-cloudtrail.html
But it doesn't show the steps that how to logging the calls with CloudTrail.
Looking forward the guidance from you all, so that we can learn together.
Thanks.
there is a text and i would need to find the word SUBSTR(
How can i acheive?
I have cluster A and cluster B. Cluster A has an external schema called 'landing_external' that contains many tables from our glue data catalog. Cluster A also has a local schema that is comprised of views that leverage data from 'landing_external' - this schema is called 'landing'.
Cluster A has a datashare that Cluster B is the consumer of. The 'landing' schema is shared with Cluster B, however, anytime a user attempts to select data from any of the views in 'landing' schema, they receive an error `ERROR: permission denied for schema landing_external`. I thought that creating all of the views with option 'WITH NO SCHEMA BINDING' would address this permission gap but it does not.
Any ideas on what I am missing?
We are currently writing a number of queries in QuickSight using SPICE for storing the results. This is fine for one-off QuickSight reports, but we'd need to write new queries and store in new SPICE when we change parameters, such as date range (i.e. changing from 1-week to 1-month reporting periods). What is best practice for what to store in SPICE: querying and storing data from single queries, or all joining data from tables and storing all data in SPICE (so that we may change query parameters in the future)?
We are using Redshift + QuickSight
If customer paid for 3 year upfront RI for Amazon Redshift, does the full payment count towards a 1 year EDP or is it prorated across 3 years?
asked 9 days ago