Hi everyone,
We have a snowplow pipeline running on production which was very stable till yesterday when it crashed. The pipeline crashed because it start complaining about two tables that we didn’t have. We added those tables and it starts working
-- Copyright (c) 2014 Snowplow Analytics Ltd. All rights reserved.
--
-- This program is licensed to you under the Apache License Version 2.0,
-- and you may not use this file except in compliance with the Apache License Version 2.0.
-- You may obtain a copy of the Apache License Version 2.0 at http://www.apache.org/licenses/LICENSE-2.0.
--
-- Unless required by applicable law or agreed to in writing,
-- software distributed under the Apache License Version 2.0 is distributed on an
-- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
-- See the Apache License Version 2.0 for the specific language governing permissions and limitations there under.
--
-- Authors: Alex Dean
-- Copyright: Copyright (c) 2014 Snowplow Analytics Ltd
-- License: Apache License Version 2.0
--
-- Compatibility: iglu:org.w3/PerformanceTiming/jsonschema/1-0-0
CREATE TABLE atomic.org_w3_performance_timing_1 (
-- Schema of this type
schema_vendor VARCHAR(128) ENCODE ZSTD NOT NULL,
show original
-- Copyright (c) 2014 Snowplow Analytics Ltd. All rights reserved.
--
-- This program is licensed to you under the Apache License Version 2.0,
-- and you may not use this file except in compliance with the Apache License Version 2.0.
-- You may obtain a copy of the Apache License Version 2.0 at http://www.apache.org/licenses/LICENSE-2.0.
--
-- Unless required by applicable law or agreed to in writing,
-- software distributed under the Apache License Version 2.0 is distributed on an
-- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
-- See the Apache License Version 2.0 for the specific language governing permissions and limitations there under.
--
-- Authors: Fred Blundun
-- Copyright: Copyright (c) 2014 Snowplow Analytics Ltd
-- License: Apache License Version 2.0
--
-- Compatibility: iglu:com.snowplowanalytics.snowplow/web_page/jsonschema/1-0-0
CREATE TABLE atomic.com_snowplowanalytics_snowplow_web_page_1 (
-- Schema of this type
schema_vendor varchar(128) encode runlength not null,
show original
My question, why snowplow start complaining about those tables now, after more than three years?
Hi @wbenzid ,
Do you have any 3rd party integrations? We had similar issues with 3rd party starting integrating Snowplow - they started to push their events to our pipeline (of course not intentionally).
Moreover, as SP is js only, it is in theory possible that anybody opened browser and entered new context. The tow you showed are created automatically with constructor, so do not need a lot of effort to be turned on…
ihor
May 29, 2019, 3:11pm
3
@wbenzid , those tables are at play when you have added the following predefined contexts to your tracking code:
contexts: {
'performanceTiming': true,
'webPage': true
}