1374641 - Deploy Splice 2.1.30 to stage

Status: RESOLVED FIXED

(Firefox :: New Tab Page, enhancement)

Description

[Nan Jiang [:nanj]]

Note this deploy has a database schema migration for Redshift:

* Include a new migration: migration/version/55df5c7c41fd_.py
* Include a new schema: ddl/migrations/redshift/1497554727.sql

Comment 1

[Nan Jiang [:nanj]]

Please grant write access to inferno for the following tables:

* assa_sessions_daily
* assa_events_daily
* assa_performance_daily
* assa_masga_daily

In prod, we'd like to give read access to "read-only" and "redash".


Thanks,
Nan

Comment 2

[Nan Jiang [:nanj]]

Please apply data expiration policy as follows:

* 90 days for assa_performance_daily and assa_masga_daily
* 180 days for assa_sessions_daily and assa_events_daily

Regarding the "activity_stream" ddfs tag, let's keep 6 month of history for now.

Comment 3

[Jon Buckley [:jbuck]]

$ cd /opt/splice/
$ cat version.json
{
	"source": "https://github.com/mozilla/splice",
	"version": "2.1.30",
	"commit": "09aeced05db3b309338e488a21fc39e21ab8197b"
}
$ SPLICE_IGNORE_REDSHIFT=true SPLICE_SETTINGS=splice_config.SpliceConfig /opt/splice/bin/python /opt/splice/bin/manage.py db upgrade
INFO  [alembic.env] Migrating database <default>
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade 25c409de54cc -> 55df5c7c41fd, empty message
INFO  [alembic.env] Migrating database stats
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade 25c409de54cc -> 55df5c7c41fd, empty message
$ psql < ddl/migrations/redshift/1497554727.sql
BEGIN
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
COMMIT
$ psql
tiles=> GRANT INSERT ON ALL TABLES IN SCHEMA public to infernyx;
GRANT
tiles=> GRANT SELECT ON ALL TABLES IN SCHEMA public TO read_only;
GRANT

Deploy to stage complete