All Questions
Tagged with amazon-redshift database
234 questions
0
votes
0
answers
119
views
AWS redshift audit log for user activity log not showing in cloudwatch
I enabled user activity log along with user log and connection log in the console properties in my redshift cluster. Despite this when I check cloud watch I only see connection log and user log.
I ...
0
votes
2
answers
53
views
merge duplicate rows where one row is null
I am using AWS Redshift. I have a table that looks like this:
Id key value1 value2 value3
1 xxx A NULL ...
- 3,390
1
vote
0
answers
52
views
If a large table is created from another large table, is that new table saved as a separate entity, or a reference to the original table?
In my scenario, I have a very large dataset with over 25 million rows (call it table B), and that is created from another table that is even larger (call it table A). I have stored this new table B as ...
- 43
0
votes
1
answer
93
views
Extract element in STRUCT data type Redshift Spectrum
I have a spectrum table with the following schema:
TABLE spectrum.table (
realmcode struct < @code: string >,
typeid struct < @extension: string,
@root: string >,
...
0
votes
0
answers
126
views
DBT Cloud scheduled job failing with error message "Database Error could not open relation with OID ******* "
I have created a scheduled job in dbt which loads the table with another table present in redshift with incremental strategy. Recently, I have started getting error while incrementally loading the ...
0
votes
1
answer
163
views
Scheduling Queries in redshift using cloudformation
I have few queries in aws redshift which I want to schedule using redshift schedule feature so that I can run those queries according to specific requirements. I want to do this work using ...
1
vote
1
answer
59
views
Getting "Caused by: java.lang.ClassNotFoundException: java.sql.SQLException" while trying to connect to amazon redshift driver
Below is the POM dependency
<dependency>
<groupId>com.amazon.redshift</groupId>
<artifactId>redshift-jdbc42</artifactId>
<version&...
- 11
0
votes
0
answers
62
views
Query getting cancelled by WLM in PROD but works fine in DEV with same WLM in Redshift
I have a query with join 6 tables. The query gets cancelled in PROD by the WLM rule. But the same query provides data in DEV. The WLM rules and data are same throughout the environment.
I tried vacuum ...
1
vote
1
answer
92
views
Why does the information_schema.table_privileges in Redshift not support the truncate type?
I want to query the select, insert, update, delete, and truncate privileges for users on tables.
However, the table_privileges view does not show the truncate privilege.
When I try to include the ...
1
vote
0
answers
52
views
How do I make the rounding function of athena match redshift?
Let's say for e.g I am calculating the average for a list of floating points e.g 405.34.
When I ROUND(avg(list),2) in Redshift - I end up with 0.01 less than if I do this in Athena.
It happens for ...
- 11
0
votes
0
answers
63
views
Redshift View Definition Restriction
Is there a way to restrict users from seeing view definition (sql)?
Code to hide view definition in redshift.
I would appreciate if you could share how to do it with the code.
Code to hide view ...
0
votes
0
answers
171
views
ST_Contains gives geometry collection error where there are none
I am writing a query in Redshift to return records where the point geometries from a table are contained within a polygon defined in the query. The expected result is a subset of the ~60000 records ...
0
votes
1
answer
364
views
Redshift Loading Data - Cannot create table with Value 1-127 Error
I am trying to create a redshift serverless db with some weather data that I have in a csv file located in a bucket. The weather data is in a clean csv format from IBM, that i extract through an API ...
0
votes
1
answer
38
views
Rolling Period Table or CTE
New to BI and Data Warehousing. A common request we get for analytics is to provide a calculation on a rolling period. For example, we would like to see how many customers we had each month in the ...
0
votes
0
answers
17
views
Create a duplicate database in amazon redshift [duplicate]
I have a database called as demo in a redshift cluster. I want to create a new database called demo_copy_feb in the same cluster with all the data in demo.
Whats the best way to do this?
- 141