--- title: Redshift Queries Iceberg Tables | daily.dev description: A hands-on guide to setting up a transactional data lake with Iceberg and querying it with Redshift. Learn about the benefits of Iceberg, creating an S3... canonical: https://daily.dev/posts/redshift-queries-iceberg-tables-k7clfi6fm twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Redshift Queries Iceberg Tables | daily.dev og:description: A hands-on guide to setting up a transactional data lake with Iceberg and querying it with Redshift. Learn about the benefits of Iceberg, creating an S3... og:url: https://daily.dev/posts/redshift-queries-iceberg-tables-k7clfi6fm og:image: https://api.daily.dev/og/posts/k7ClFi6FM.png og:image:alt: Redshift Queries Iceberg Tables og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Redshift Queries Iceberg Tables **[AWS Community](https://daily.dev/sources/awscommunity)** · 6 min read · 0 upvotes · 0 comments ## Summary A hands-on guide to setting up a transactional data lake with Iceberg and querying it with Redshift. Learn about the benefits of Iceberg, creating an S3 bucket, copying data into the bucket, creating a workgroup in Athena, creating a table in Glue, creating a crawler in Glue to retrieve schema and create a table, creating an Iceberg table, inserting data into the table, setting up permissions and security for Athena and Redshift, querying data from an Iceberg table in Athena, and the limitations of Redshift Queries with Iceberg Tables. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: --- Tags: [#aws](https://daily.dev/tags/aws), [#aws-s3](https://daily.dev/tags/aws-s3), [#redshift](https://daily.dev/tags/redshift) [View this post on daily.dev](https://daily.dev/posts/redshift-queries-iceberg-tables-k7clfi6fm) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"Redshift Queries Iceberg Tables","url":"https://daily.dev/posts/redshift-queries-iceberg-tables-k7clfi6fm","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/redshift-queries-iceberg-tables-k7clfi6fm"},"datePublished":"2024-02-02T08:20:40.188Z","dateModified":"2024-05-09T07:55:57.971Z","description":"A hands-on guide to setting up a transactional data lake with Iceberg and querying it with Redshift. Learn about the benefits of Iceberg, creating an S3...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/75c71a70ba99e160bfa62268af86a091?_a=AQAEufR","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/75c71a70ba99e160bfa62268af86a091?_a=AQAEufR","isAccessibleForFree":true,"articleSection":"AWS Community","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"AWS Community","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/8d3ee64e7e4d4a65bb2135d02088600d","url":"https://daily.dev/sources/awscommunity"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/redshift-queries-iceberg-tables-k7clfi6fm","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"aws,aws-s3,redshift","timeRequired":"PT6M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"AWS Community","item":"https://daily.dev/sources/awscommunity"},{"@type":"ListItem","position":3,"name":"Redshift Queries Iceberg Tables"}]} ```