Kaushik IskaforPeerDB Blogblog.peerdb.io·May 7, 2024PeerDB Cloud is Now in Public Beta!🚀 Today, we're excited to announce that PeerDB Cloud is officially entering public beta. If you're a data engineer or an organization looking for a fast, simple, and cost-effective way to replicate data from Postgres to data warehouses such as Snowf...Discuss·1 like·96 readsdata-movement
Sourabh Guptaonlydataengineering.hashnode.dev·Apr 22, 2024How to Load Data from SQL Server to SnowflakeIn today's data-driven world, organizations often need to migrate their data from one system to another for various reasons, such as consolidating data sources, upgrading to a more modern and efficient platform, or enabling advanced analytics. One co...DiscussSql server to Snowflake
Nikhil ThomasforSnow Forged Machine Minds (SFM2)sfm2.ai·Mar 12, 2024Data Engineering Foundations: A Practical Introduction to Snowflake, Fivetran, and dbtWelcome to our exciting journey through the world of data integration and transformation! Today, we're diving into a practical project that involves a trio of modern data tools: Snowflake, Fivetran, and dbt. Whether you're a data enthusiast, a profes...Discuss·177 readsfivetran
Daniel Olusesitechvillian.hashnode.dev·Feb 24, 2024Unlock the Power of the Cloud: How PostgreSQL Supercharges Your Data Storage and WarehousingIntroduction: In today's digital landscape, data holds the key to unlocking insights and driving informed decision-making. PostgreSQL stands out as a powerful tool in this endeavor, offering a robust platform for managing both structured and unstruct...Discuss·15 likes·87 readsPostgreSQL
Stefan StarkeforCloudflight Engineering Blogengineering.cloudflight.io·Feb 14, 2024Lakehouse: Securing data accessIn this article, we'll delve into best practices for securing data access when using Microsoft Fabric Lakehouses. The goal is ensuring that your valuable data remains protected and enable people from within your organization to see subsets of the dat...Discuss·369 readsfabric
Kunal GuptaforPeerDB Blogblog.peerdb.io·Jan 17, 2024SSH Tunneling for Secure Postgres ReplicationAt PeerDB, we are building a fast and a cost-effective way to replicate data from Postgres to Data Warehouses, Queues and Storage. This blog post talks about how PeerDB accesses Postgres Databases securely via SSH Tunneling and moves data to any of i...Discuss·1 like·2.0K readsPostgreSQL
Nkoyo Ekponkoyoekpo.hashnode.dev·Oct 14, 2023Demystifying Database, Data Warehouse, and Data Lake: Unraveling the DifferencesAccording to a recent survey by Datanami, databases are the most widely used data storage technology, followed by data lakes and data warehouses. The survey found that 86% of respondents use databases, 68% use data lakes, and 61% use data warehouses ...DiscussDatabases
Annis Souamesanniscodes.com·Sep 16, 2023A Short Primer on Fact Tables - Data WarehousingI remember when I had my first business intelligence course, we were introduced to different dimensional modelling concepts such as fact tables, dimensions, the Kimball approach, the Inmon approach, etc. It was a bit confusing and overwhelming at fir...Discussdata-warehousing
Sean Coughlinblog.seancoughlin.me·Sep 9, 2023Understanding the Landscape of Data Storage: A Comprehensive Guide to AWS DynamoDB vs. Redshift for Databases and Data WarehousesThe topics of databases and data warehouses are central to the modern data landscape, and Amazon's offerings—DynamoDB and Redshift—are standout products in their respective categories. Here's a detailed comparison: Database vs. Data Warehouse Dat...Discuss·37 readsCloud ComputingAWS
Constantin Lungudatawise.dev·Aug 16, 2023A portable data stack with Dagster, Docker, DuckDB, dbt and SupersetI've previously mentioned how pet projects are good for exploring new technologies. It's not every day that you can work on a greenfield project with just the stack you want. So while ago I decided to spin off a previous proof of concept I've had (po...Discuss·1 like·835 readsLearning Journeydbt