Vipul Tripathiitsvipul.hashnode.net·Feb 17, 2023Snowflake vs its AlternativesSnowflake is a cloud-based data warehousing platform that provides users with an unprecedented level of data integration, management, and analysis. The platform is designed to meet the demands of modern data-driven businesses, offering a range of fea...Discuss·22 likes·203 readsZero to Snowflakesnowflake
Timothy Nduatitimothynn.hashnode.net·Jan 19, 2023How to find Median in SQL DatabaseSince median is harder than min/max/count and not a standard aggregate function, we’ll need to do a little more work to calculate it. Here’s how on several different databases: Median on Redshift The Redshift team recently released a median window fu...Discuss·10 likes·69 readsSQLDon't forget to leave a like and follow Timothy Nduati for more #SQL content 5
Nidhi Sharmanidhidevops.hashnode.net·Mar 28, 2023DatabasesIf you are from a non-technical background, And still want to know what is databases, Please don't worry guys, I will make you understand what are databases with Images and will see what all database services are provided by AWS. Let's begin... What ...Discuss·2 likes·27 readsDatabases
Alexandra Skidansashaxenoss.hashnode.net·Apr 25, 2023BigQuery/Redshift/ClickHouse: How to choose the best database management system for AdTech projectsAdTech products’ success rates are predicated on the efficient collection and use of big data — but more importantly, on how it is stored, processed, and analyzed. Advertising platforms must deliver multi-dimensional insights on real-time and histori...DiscussAd Tech Market
gyan pratap Singhrocketgps.hashnode.net·Apr 21, 2023About RedshiftIntroduction to Amazon Redshift Tens of thousands of customers today rely on Amazon Redshift to analyze exabytes of data and run complex analytical queries, making it a widely used cloud data warehouse. How it works Amazon Redshift uses SQL to analyz...Discussredshift
Aayush Kurupaayushkurup.hashnode.net·Apr 14, 2023From Relational to Analytical: The Power of Redshift Data Warehousing and AnalyticsI recently got my hands dirty working on data warehousing and found myself wondering why traditional databases like Postgres aren't commonly used for this task. After some research and experimentation, I discovered that specialized data warehousing s...Discuss·58 readsdata-warehousing
Nidhi Sharmanidhidevops.hashnode.net·Mar 28, 2023DatabasesIf you are from a non-technical background, And still want to know what is databases, Please don't worry guys, I will make you understand what are databases with Images and will see what all database services are provided by AWS. Let's begin... What ...Discuss·2 likes·27 readsDatabases
Deekshith Reddydeekshithreddy.hashnode.net·Mar 15, 2023Managing Redshift Data: Unloading and Restoring with EaseIn this blog post, we will explore how to unload a Redshift table to S3 and restore the CSV into the Redshift table. Introduction:Amazon Redshift is a fully-managed data warehouse service in the cloud, designed for enterprise-level data storage and...Discuss#datawarehouse
Vu Daovumdao.hashnode.net·Feb 25, 2023AWS CDK Redshfit DemoAbstract For getting started with AWS Redshift, this post guides you to provide Redshift cluster and all necessary other resources such as VPC, redshift IAM role, S3 bucket where we load data to Amazon Redshift and a small EC2 instance as PostgreSQL...Discuss·26 readsAWS
Jonathan Reisjreissup.hashnode.net·Feb 23, 2023Implementing a Data Lakehouse Architecture in AWS — Part 3 of 4Introduction In our previous article, part 2 of the series, we walked through the extraction, processing, and creation of some data mart, using the New York City taxi trip data which is publicly available to do consumption. We used some of the princi...DiscussExploring the Data Lakehouse and Its Implementation in AWSData-lake
Vipul Tripathiitsvipul.hashnode.net·Feb 17, 2023Snowflake vs its AlternativesSnowflake is a cloud-based data warehousing platform that provides users with an unprecedented level of data integration, management, and analysis. The platform is designed to meet the demands of modern data-driven businesses, offering a range of fea...Discuss·22 likes·203 readsZero to Snowflakesnowflake
Timothy Nduatitimothynn.hashnode.net·Jan 19, 2023How to find Median in SQL DatabaseSince median is harder than min/max/count and not a standard aggregate function, we’ll need to do a little more work to calculate it. Here’s how on several different databases: Median on Redshift The Redshift team recently released a median window fu...Discuss·10 likes·69 readsSQLDon't forget to leave a like and follow Timothy Nduati for more #SQL content 5
Harry Patelpatelsaheb.hashnode.net·Jan 19, 2023AWS Redshift : How to start?TL;DR Amazon's redshift service makes life easier for analytics processes without managing Data Warehouse. We can use it for real-time processing and prediction of data. Redshift is just a flavor of PostgreSQL. The idea behind this article is to how ...DiscussAWS
