Questions tagged [redshift]
10 questions
7
votes
2 answers
What does it mean when Redshift gives you "invalid end key specified" on a dynamo table load?
Doing a dynamo load into redshift I got this error that didn't show up in the Redshift docs or as a literal string into google at all.
# copy redshift_table_name from 'dynamodb://DYANAMOTABLENAME' credentials…
Ry4an Brase
- 491
6
votes
1 answer
Why does running Redshift commands from crontab does not seem to work?
About redshift:
Redshift adjusts the color temperature of your screen according to your surroundings.
A typical redshift command that I use is redshift -O 9999 which sets the screen color temperature at 9999K. Following a polyphasic sleep…
ToonAlfrink
- 130
4
votes
0 answers
Reading data from Amazon redshift in Spark 2.4
We used to read data in Spark 2.3 using databricks with the following code segment
Spark-Shell initialization :
spark-shell --jars RedshiftJDBC42-1.2.10.1009.jar --packages…
2
votes
1 answer
Invalid operation: Assert - Error in Redshift
I am getting an Assert error that I've never seen before within Redshift.
I created a CTE (let's call it seed) that joins 6+ tables.
From the CTE, I need to do some aggregations and transformations of data. I do this within another CTE (let's call…
aggis
- 121
1
vote
1 answer
How can effects of "xrandr --output eDP --brightness 0.3" and "redshift -r -P -O 3800" be merged?
Seeking darker screen, and redshifted, combined,
how can the effect of (e.g.)
xrandr --output eDP --brightness 0.3 --verbose
and
redshift -r -P -O 3800
be merged, so both xrandr's --brightness 0.3, and redshift's 3800 are both in effect?
Running…
digit
- 129
0
votes
1 answer
How to connect an ODBC data source to Redshift through an Azure SSO identity provider?
We've setup an Azure identity provider to allow our users to access a Redshift data warehouse using their Entra identities using SSO. We've been able to configure a JDBC driver so that SQL administration programs like DBeaver can access the data…
Woody1193
- 103
- 2
0
votes
0 answers
Excel instance very slow when returning data from redshift database
I don't have many details for this since I can't reproduce it on my side, so here goes.
We have an Excel that that displays data returned from a redshift data. For the purposes of the question, I simply created a new Excel file (xlsx), went to…
rbhat
- 521
0
votes
1 answer
Can I load .dsv files from S3 to Redshift / SQL Workbench, or convert them to another file type in S3?
I have a lot of files in .dsv format from a client, and I need to get them into SQL Workbench. I have previously only loaded .txt and .csv before and cannot find documentation.
Is it possible to copy .dsv files, and if so, how?
Is it possible to…
0
votes
1 answer
Autostart redshift-gtk in Window Maker and prevent it to run twice
I struggled to launch redshift-gtk at Window Maker startup.
Moreover, editing a dockable icon would not prevent the app to be load twice (I noticed it's the case at WMaker startup, I don't know what it happens). Also it may stay "greyed out" since…
Amessihel
- 355
0
votes
0 answers
AWS Redshift failed to inflateinvalid or incomplete deflate data while inserting a zipped csv file
I have a zipped csv file which is a part of a huge file, and extracted from the original huge file using the following command:
gunzip -c myFile.csv.gz | head -n 500000 > myFile.csv.gz_p1
after making the smaller file, I need to insert it into a…
Cyrus
- 101