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)