how do I know what tables should I create? I understand it depends on the tracking purposes but still - is there documentation which tables should be used for which activity?
You are right. It is not well documented in the wiki. Although, the following Discourse post should help you out to some extend: Redshift tables mapping. You are welcome to contribute to this list when you find a missing table.
how to track properly enableLinkClickTracking
You should be able to find a few posts in this forum you could follow. The corresponding wiki page is here: 2 Specific event tracking with the Javascript tracker · snowplow/snowplow Wiki · GitHub.
Redshift, all entries are page_ping . What is the way to configure the above tracker to track page view and link clicks?
Could you swap link tracking with pageviews and see it that helps
window.snowplow('enableActivityTracking', 30, 10);
window.snowplow('trackPageView');
window.snowplow('enableLinkClickTracking', null, true, true);
I also noticed non-ASCII quote (‘ vs '). Could be just a copy/paste issue but might be the reason the events did not fire.
If you still have a problem do create a new post.