snowplow-archive / schema-guru

JSONs -> JSON Schema
http://snowplowanalytics.com
150 stars 20 forks source link

Placeholder for supporting migration cases #140

Closed chuwy closed 7 years ago

chuwy commented 8 years ago

Here I'm collecting possible Schema-migrations and ways to handle it

ALTER TABLE ADD COLUMN ...
ALTER TABLE ADD COLUMN customer_id_new string null;
INSERT INTO customer_id_new SELECT from customer_id;
ALTER TABLE DROP COLUMN customer_id;
ALTER TABLE RENAME COLUMN customer_id_new TO customer_id
END TRANSACTION;
alexanderdean commented 8 years ago

How about:

  1. A default is added to a property (Addition)
  2. A minimum and/or maximum value is removed from a numeric (Revision)
chuwy commented 7 years ago

Migrated to https://github.com/snowplow/iglu/issues/241