skyfirehose.com - Query the Bluesky Jetstream with DuckDB

This will print a SQL statement (CREATE SECRET s3secret (...);) which contains the temporary credentials. You need to copy this statement for the next step.

The secret from step 1) is valid for 15 minutes. Please paste the copied statement into your local DuckDB instance and execute it. Once you have executed the statement, you can start accessing the Bluesky Jetstream data.

duckdb

ATTACH 'https://skyfirehose.com/database' AS bluesky;

Leave a Comment