README.md in logstash-output-charrington-0.3.13 vs README.md in logstash-output-charrington-0.3.14

- old
+ new

@@ -83,9 +83,46 @@ ``` Sometimes the embedded postgres JAR can leave dangling open processes. This is obvious when you have `export TEST_DEBUG=true` and the test output contains a stacktrace that starts with `[2019-06-21T15:18:06,734][ERROR][ru.yandex.qatools.embed.postgresql.PostgresProcess] Failed to read PID file (File '/var/folders/...`. To resolve this issue, check for dangling processes using `lsof -PiTCP -sTCP:LISTEN | grep postgres`, then you can kill the process ids +#### Tracks Table +**Create Statment for Driver is Postgres and Transform is Redshift** + * See `@@redshift_tracks_columns` in [insert.rb](./lib/logstash/outputs/charrington/insert.rb) for column list +```sql +create table <schema>.tracks +( + id varchar(512) not null constraint tracks_pkey primary key, + anonymous_id varchar(512), + app_name varchar(512), + context_campaign_content varchar(512) + context_campaign_medium varchar(512), + context_campaign_name varchar(512), + context_campaign_source varchar(512), + context_ip varchar(512), + context_library_name varchar(512), + context_library_version varchar(512), + context_page_path varchar(512), + context_page_referrer varchar(512), + context_page_search varchar(512), + context_page_title varchar(512), + context_page_url varchar(512), + context_user_agent varchar(512), + event varchar(512), + event_text varchar(512), + original_timestamp timestamp, + received_at timestamp, + segment_dedupe_id varchar(512), + sent_at timestamp, + timestamp timestamp, + user_id varchar(512), + user_uid varchar(512), + uuid bigint, + uuid_ts timestamp default ('now'::text)::timestamp without time zone, +) + +``` + #### Resources * [logstash-devutils](https://rubygems.org/gems/logstash-devutils) gem with logstash helper methods and tools * [spec_helper.rb source](https://github.com/elastic/logstash-devutils/blob/master/lib/logstash/devutils/rspec/spec_helper.rb) * [logstash_helpers.rb source](https://github.com/elastic/logstash-devutils/blob/master/lib/logstash/devutils/rspec/logstash_helpers.rb) * [logstash-output-file spec test](https://github.com/logstash-plugins/logstash-output-file/blob/master/spec/outputs/file_spec.rb)