We have some trouble getting data into the web schema (and two tables in atomic too)
We noticed that when running these queries, they constantly outputs: ROWS AFFECTED: -1 with not data going into any of the tables, even though we have plenty of events in the atomic.events table. Why is this?
I also noticed that the two tables atomic.com_snowplowanalytics_snowplow_web_page_1 and atomic.org_w3_performance_timing_1 (which we had to create to make the queries run in the first place) are both empty - I wonder if that has to do with why the above mentioned queries are not populating the web schema? If that’s the case, then how do I get data into those two tables? NB! We have not added any enrichment jsons for those two tables, as we could not find anywhere in the documentation if that were needed or if they are run by standard…
Some of the tables used in the playbooks reference things like the web_page and performance_timing contexts. By default these aren’t turned on - this tends to be a sane default as they can be quite noisy - but they can be switched on easily using whatever tracker library you’re using.
To the JS tracker, I now have data in the atomic.com_snowplowanalytics_snowplow_web_page_1 and atomic.org_w3_performance_timing_1 tables - great!
However, no data is coming into the tables in web schema still. What could I be lacking/doing wrong. This is the output then I run the sql scripts using sql_runner./sql-runner -playbook au-snowplow-sql/playbooks/web-model.yml.tmpl:
SOLVED And another update. Turned out, that due to a missing enrichment config for the ua_parser, the com_snowplowanalytics_snowplow_ua_parser_context_1 table was not populated, causing nothing to end up in the web schema. Now it all works. Great