8,790 questions
0
votes
0
answers
17
views
writing data from aws glue catalog to redshift
scenario
I have glue catalog and I need to load this data from catalog to redshift.
dyf = glueContext.create_dynamic_frame.from_catalog(
database=catalog_db,
table_name=f"{...
- 11
0
votes
2
answers
34
views
ERROR: permission denied for relation stl_query, how to resolve?
I am trying out Redshift and at first, I am trying to access queries I ran in the past but was hit by this error: ERROR: permission denied for relation stl_query and tried to grant access as well but ...
- 659
-1
votes
1
answer
41
views
As a SQL developer, what are the differences between RDS and redshift that I'll notice?
I have solid experience with redshift (primarily SQL development) since I've been migrating our objects from SQL Server to redshift for the past year. In a nutshell, I've had to take t-sql (in the ...
- 3,283
0
votes
0
answers
8
views
Make Looker Studio <> AWS Redshift use aggregate queries
I have a column called “total_revenue_earned” and another called “purchase_month”. If I try to make a bar chart summing revenue by month the query Looker Studio uses involves no aggregate functions. ...
- 183
0
votes
1
answer
29
views
How can I connect Google Looker Studio with AWS Redshift?
I am trying to connect Looker Studio with Amazon Redshift but keep getting this error
I had to make sure everything related to connection details was the same and also tried to connect with Basic and ...
- 659
0
votes
1
answer
37
views
AWS Redshift spectrum not able to return data for external table where data type timestamp
I'm trying to query data through Redshift Spectrum using an external schema from the Glue catalog but encountering an issue with a column that has a timestamp data type. When I run the query SELECT * ...
- 339
0
votes
0
answers
29
views
boto3 redshift client .describe_statement provides no error message
I've run an sql query through boto3 redshift client's execute_statement function, and subsequently checked the status of the query with describe_statement.
result = client_redshift.execute_statement(...
- 669
0
votes
1
answer
55
views
Redshift COPY query hangs. (Running but not submitted) (Table size just 30 rows)
I have been running COPY commands on Redshift in query editor and boto3 (programatically), successfully.
However, after yesterday, neither method works.
Although, cluster console shows that query is ...
0
votes
0
answers
27
views
Is there any way to get more detailed syntax error messages in Redshift SQL?
I am re-writing some 1000+ line queries which were written originally for a PostgreSQL DB and now have to run on near-identical data in Redshift (using Redshift Serverless and the QueryEditorV2). This ...
- 127
0
votes
0
answers
28
views
Create table from another table, but only the primary column
From a table, how can I create another table without the data and with only the primary key columns?
I am able to get the primary key columns using the following query:
SELECT column_name
FROM ...
- 504
1
vote
3
answers
55
views
fill gaps in outer join in redshift
I have a table that contains products and sales data. Unfortunately, not every month a given product was sold, and I would like unsold products in a given month to also be shown. In Oracle, the query ...
- 41
1
vote
2
answers
330
views
Unable to create AWS Glue Connection to RedShift Serverless
I am trying to create a connection between AWS Glue and the Redshift database in Glue. Currently, I am getting an error:
Connection creation is failed.
Create connection failed during validating ...
- 746
1
vote
1
answer
79
views
Is there a SQL feature to return the max value for every column?
Background: I have a unique setup with multiple tables, each with circa 1,600 columns, which I am trying to clean up (it creates benefits upstream). I know that around 80% of these columns will always ...
- 43
0
votes
1
answer
43
views
in GA4，the daily exported events are about to exceed 1 million. What should I do next?
I am using the Daily Export method to export some GA events to BigQuery, but the daily event volume is about to exceed 1 million. If I switch to the Streaming method, I might lose information such as ...
- 1
0
votes
1
answer
38
views
How to Extract Nested JSON Array in Redshift and Create a Table with Specific Columns?
I have a table in AWS Redshift with a column called json, which stores a nested JSON object as a string. I need to create a new table with three columns: sid, skill_name, and skill_vdd. The json ...
- 1,655