Skip to content

Instantly share code, notes, and snippets.

@morsapaes

morsapaes/twitch_source_postgres.sql

Last active August 31, 2021 09:19
Show Gist options
  • Save morsapaes/64d5982561987e68a9c2459425aaea65 to your computer and use it in GitHub Desktop.
Save morsapaes/64d5982561987e68a9c2459425aaea65 to your computer and use it in GitHub Desktop.
Download ZIP
Analyzing Twitch streams with Materialize: Postgres source
Raw
twitch_source_postgres.sql
CREATE MATERIALIZED SOURCE mz_source
FROM POSTGRES
CONNECTION 'host=postgres port=5432 user=postgres dbname=postgres password=postgres'
PUBLICATION 'mz_source';
CREATE VIEWS FROM SOURCE mz_source (stream_tag_ids);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment