StorageLoader error

Hello There,
While running storage loader script I am getting this error.
ERROR: Cannot COPY into nonexistent table com_google_analytics_cookies_1

Any missing tables can be found in our snowplow repository on GitHub - in your case this is the table:

https://github.com/snowplow/snowplow/blob/master/4-storage/redshift-storage/sql/com.google.analytics/cookies_1.sql

Deploy this into your Redshift database and rerun the StorageLoader.

Hi @alex, I was wondering what has happened to the queries for these tables? The repo currently contains only sql queries for creating the atomic.events table.

minutes later and I found the answer. These queries have been moved to Iglu Central and the query for this specific table can be found here

1 Like