--- title: Best Data Warehouse posts of 2023 | daily.dev description: The most upvoted Data Warehouse posts of 2023, curated by the daily.dev community. canonical: https://daily.dev/tags/data-warehouse/best-of/2023 twitter:card: summary_large_image twitter:site: @dailydotdev og:url: https://daily.dev/tags/data-warehouse/best-of/2023 og:type: website og:site_name: daily.dev og:title: Best Data Warehouse posts of 2023 | daily.dev og:description: The most upvoted Data Warehouse posts of 2023, curated by the daily.dev community. og:image: https://media.daily.dev/image/upload/s--VAY5ToZt--/f_auto/v1724209435/public/daily.dev%20-%20open%20graph --- # Best of Data Warehouse — 2023 1. 1 [](/posts/16-sql-techniques-every-beginner-needs-to-know-rowxlf3md "16 SQL Techniques Every Beginner Needs to Know") Article Hacker Noon · 4y 16 SQL Techniques Every Beginner Needs to Know Learn SQL techniques for data warehousing, including handling incremental tables, using MERGE statements, and converting tables to JSON objects. 102 5 2. 2 [](/posts/ep66-comparison-of-url-uri-and-urn-wxfvjob96 "EP66: Comparison of URL, URI, and URN") Article ByteByteGo · 3y EP66: Comparison of URL, URI, and URN This week’s system design refresher: OAuth 2 explained in simple terms. The diagram below shows a comparison of URL, URI, and URN. Do you know the differences? Do you use a data warehouse or a data lake to retrieve data? Twitter 1.0 Tech Stack is the biggest technology newsletter on Substack. 36 3. 3 [](/posts/data-engineer-project-postgres-database-to-s3-datalake-to-postgres-data-warehouse-prep-coff-ovf5yl2sj "Data Engineer Project: Postgres (Database) to S3 (DataLake) to Postgres (Data Warehouse) | Prep Coffee Inventory Management") Article Medium · 3y Data Engineer Project: Postgres (Database) to S3 (DataLake) to Postgres (Data Warehouse) | Prep Coffee Inventory Management This post discusses a data engineer project that involves transforming data from a PostgreSQL database to an S3 datalake and then to a PostgreSQL data warehouse. The author shares their experience and methodology, as well as the tools used. They also highlight the problems they faced during the project. 14 4. 4 [](/posts/what-is-etl-difference-between-etl-and-elt-kfjbceae7 "What is ETL? Difference between ETL and ELT") Article Decube · 3y What is ETL? Difference between ETL and ELT ETL and ELT are two approaches to data integration. ETL involves extracting data from source systems, transforming it into an analysis-ready format, and loading it into a data warehouse. ELT involves loading data into the target system first and transforming it as needed. 13 [See all Data Warehouse archives](/tags/data-warehouse/best-of) ```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","@graph":[{"@type":"CollectionPage","@id":"https://daily.dev/tags/data-warehouse/best-of/2023#page","url":"https://daily.dev/tags/data-warehouse/best-of/2023","name":"Best Data Warehouse Posts of 2023","description":"The most upvoted Data Warehouse posts of 2023, curated by the daily.dev community.","isPartOf":{"@type":"WebSite","url":"https://daily.dev"}},{"@type":"ItemList","@id":"https://daily.dev/tags/data-warehouse/best-of/2023#items","numberOfItems":4,"itemListElement":[{"@type":"ListItem","position":1,"url":"https://daily.dev/posts/16-sql-techniques-every-beginner-needs-to-know-rowxlf3md","name":"16 SQL Techniques Every Beginner Needs to Know"},{"@type":"ListItem","position":2,"url":"https://daily.dev/posts/ep66-comparison-of-url-uri-and-urn-wxfvjob96","name":"EP66: Comparison of URL, URI, and URN"},{"@type":"ListItem","position":3,"url":"https://daily.dev/posts/data-engineer-project-postgres-database-to-s3-datalake-to-postgres-data-warehouse-prep-coff-ovf5yl2sj","name":"Data Engineer Project: Postgres (Database) to S3 (DataLake) to Postgres (Data Warehouse) | Prep Coffee Inventory Management"},{"@type":"ListItem","position":4,"url":"https://daily.dev/posts/what-is-etl-difference-between-etl-and-elt-kfjbceae7","name":"What is ETL? Difference between ETL and ELT"}]},{"@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Tags","item":"https://daily.dev/tags"},{"@type":"ListItem","position":3,"name":"Data Warehouse","item":"https://daily.dev/tags/data-warehouse"},{"@type":"ListItem","position":4,"name":"Best of","item":"https://daily.dev/tags/data-warehouse/best-of"},{"@type":"ListItem","position":5,"name":"2023"}]}]} ```