Skip to content

Instantly share code, notes, and snippets.

@crowdmatt

crowdmatt/s3-redshift-load.rb

Created April 26, 2013 00:25
Show Gist options
  • Save crowdmatt/5464314 to your computer and use it in GitHub Desktop.
Save crowdmatt/5464314 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. crowdmatt created this gist Apr 26, 2013.
    3 changes: 3 additions & 0 deletions s3-redshift-load.rb
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,3 @@
    ActiveRecord::Base.connection.execute(
    "copy campaign_events from 's3://BUCKET/FILEPATHPREFIX/' credentials 'aws_access_key_id=XXX;aws_secret_access_key=XXX' emptyasnull blanksasnull fillrecord delimiter '|'"
    )