Just want to say Redshift connectivity is important for me too. BTW is there a google BigQuery adapter?
Cheers. On Fri, Feb 27, 2015 at 8:58 AM, <[email protected]> wrote: > I've been trying to get this to work for a while now without any success. > > We have an Amazon Redshift database. I want to execute custom SQL queries > against it, like select count or load files. > > The two main approaches I've tried are using the postgres adapter and > using the sequel-redshift (https://github.com/remind101/sequel-redshift) > gem. Since I'm mostly going to be running raw SQL against it, I am fine w/ > a postgres adapter, but both of those give me an error about unrecognized > configuration parameter "standard_conforming_strings" > > db = Sequel.connect('redshift:// > admin:mypassw...@mycompany-dw.klasdf8390a.us-east-1.redshift.amazonaws.com:5439/dev > ') > > db.fetch("SELECT COUNT(*) FROM mytable").all > > Sequel::DatabaseConnectionError: PG::UndefinedObject: ERROR: unrecognized > configuration parameter "standard_conforming_strings" > > Can someone help me? > > Thanks! > > -- > You received this message because you are subscribed to the Google Groups > "sequel-talk" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/sequel-talk. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sequel-talk. For more options, visit https://groups.google.com/d/optout.
