blog_post_tags
7 rows where blog_post_hash = "2d28a075e6"
This data as json, CSV (advanced)
Link | blog_post_hash | tag_hash |
---|---|---|
2d28a075e6,04fde7d1b7 | Podcast 293: Diving into Data with Amazon Athena 2d28a075e6 | Analytics 04fde7d1b7 |
2d28a075e6,0dcb092a8e | Podcast 293: Diving into Data with Amazon Athena 2d28a075e6 | Blog Post 0dcb092a8e |
2d28a075e6,1846508a68 | Podcast 293: Diving into Data with Amazon Athena 2d28a075e6 | amazon-athena 1846508a68 |
2d28a075e6,607aee300f | Podcast 293: Diving into Data with Amazon Athena 2d28a075e6 | Podcast 607aee300f |
2d28a075e6,6aa3bfa11f | Podcast 293: Diving into Data with Amazon Athena 2d28a075e6 | podcast 6aa3bfa11f |
2d28a075e6,6ad4a30dae | Podcast 293: Diving into Data with Amazon Athena 2d28a075e6 | Amazon Athena 6ad4a30dae |
2d28a075e6,bc552ec364 | Podcast 293: Diving into Data with Amazon Athena 2d28a075e6 | analytics bc552ec364 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "blog_post_tags" ( [blog_post_hash] TEXT REFERENCES [blog_posts]([hash]), [tag_hash] TEXT REFERENCES [tags]([hash]), PRIMARY KEY ([blog_post_hash], [tag_hash]) ); CREATE INDEX [idx_blog_post_tags_tag_hash] ON [blog_post_tags] ([tag_hash]); CREATE INDEX [idx_blog_post_tags_blog_post_hash] ON [blog_post_tags] ([blog_post_hash]);