python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - amazon-redshift

How to connect to a redshift database with Cypress?

I am having issues trying to connect to a redshift database on Cypress, I've followed the instructions from the official cypress-sql-server webpage, please see my configurations files below --> cyp...
test-img

shaveax

javascript

sql

node.js

amazon-redshift

cypress

Votes: 0

Answers: 0

Get the max date of dates in a column that are > than 6 days prior to another date column

I have data where I want to compare what date was given 6 days or more prior to another date. Example: the actual date time is 15th Jan 2022, I would like to see what the estimated time was 6 or more ...
test-img

T walker

sql

date

amazon-redshift

Votes: 0

Answers: 1

Latest Answer

worked it out by reading more SELECT foe.load_id, foe.estimated_arrival_time eta, fol.pod_vessel_arrival_time ata, foe.event_date_time, foe.shipper, foe.carrier, fol.load_n...
test-img

T walker

SQL, extract everything before 5th comma

For example, my column "tags" have "movie/spiderman,genre/action,movie:marvel", "movie/kingsman,genre/action", "movie/spiderman,genre/action,movie:marvel,movie:dfjk...
test-img

sopL

sql

regex

amazon-web-services

amazon-redshift

Votes: 0

Answers: 1

Latest Answer

You can use REGEXP_REPLACE(tags, '^(([^,]*,){4}[^,]*).*', '\\1') See the regex demo. The REGEXP_REPLACE will find the occurrence of the following pattern: ^ - start of string (([^,]*,){4}[^,]*) - Gr...
test-img

Wiktor Stribiżew

Minimizing Disk Spaced used on Redshift Table

I'm working with machine telemetry data, so I've got a ton of time-series sensor readings for various runs of a process. I believe there are some disk usage savings to be had if I store the data diffe...
test-img

Chris Decker

amazon-redshift

Votes: 0

Answers: 1

Latest Answer

There are several ways that table space can be reclaimed. First is compression (encoding) which you are looking at. Best advice is to compress everything especially data columns. There are only a fe...
test-img

Bill Weiner

Posts

Questions

Blogs

Jobs