Databases What Are dbt Sources? We dive into what dbt sources are, how they work, and how you can use them to advance your data warehouse.
Learning The Complete Guide to Data Staging In this in-depth guide, Zuar explains what data staging is, why it's important, types of data staging, software staging best practices, and more.
Learning Data Transformation: Types, Process, Benefits & Definition What is data transformation? What are the benefits of data transformation? What are the processes? Learn all this and more!
Learning Data Integration Patterns Explained Learn about the top 5 most common data integration patterns: data migration, broadcast, bi-directional sync, correlation, and aggregation.
Databases Data Mesh vs. Data Fabric vs. Data Lake Learn the differences between data lakes, data mesh, and data fabric and how your organization can leverage these frameworks in your data stack.
Learning What is a Data Silo? Learn what a data silos is, how they negatively impact your business, how to identify and eliminate them, and frequently asked questions .
Databases Snowflake Data Deletion, Recovery & More: Including How to Delete a Table Overview of the best practices for safely deleting & recovering data in a Snowflake database, including tables and rows.
Databases Data Migration: Business Considerations & Implications Migrating databases is a costly but worthwhile data strategy investment. See what considerations there are for businesses undertaking such an initiative.
Databases Reverse ETL vs. ETL vs. ELT Learn about the key differences between ETL, ELT, and Reverse ETL and how they can be leveraged in your data integration strategy.
Databases What is Google Cloud Composer? Get an overview of Google Cloud Composer, including the pros and cons, an overview of Apache Airflow, workflow orchestration, and frequently asked questions.
Databases Amazon Redshift DATEDIFF Function: Cheat Sheet & FAQ This how-to guide explains Redshift's DATEDIFF function including arguments, examples, related functions, and frequently asked questions.
Databases What is Amazon DocumentDB? Amazon DocumentDB basics including types of NoSQL databases, DynamoDB vs. DocumentDB vs. MongoDB, and instructions for DocumentDB development.
Learning Exploring the Data Value Chain See how companies create value with data, better understand the data lifecycle, and learn how to implement the data value chain.
Databases What is Google BigQuery? Learn the basics of Google BigQuery including features and functionality, SQL examples, the architecture, and more.
Databases Amazon S3 Overview & Cheat Sheet Use this cheat sheet to quickly reference common S3 commands, buckets, storage classes, lifecycle management, and frequently asked questions.
Databases Cheat Sheet for Amazon DynamoDB Use this cheat sheet to quickly reference common Amazon DynamoDB commands, identity and access management, and more.
Databases BigQuery Cheat Sheet Use this cheat sheet to quickly reference some of the most common Google BigQuery commands, expressions, data types, and more.
Databases Cheat Sheet for MariaDB SQL Database Commands This is a quick reference MariaDB cheat sheet for the most commonly used MariaDB SQL database commands.
Databases What is Amazon EMR? Amazon EMR (Elastic Map Reduce) is a managed 'Big Data' service offering from AWS (Amazon Web Services). With it, organizations can process and analyze massive amounts of data.
Databases Apache Spark Cheat Sheet Use this quick reference cheat sheet for the most common Apache Spark coding commands.
Learning How to Convert CSV to SQL Do you need a solution to convert CSV to SQL? This guide will provide you with the best methods and solutions to transform your data.
Databases Cloud Computing Trends for 2022 Cloud computing is a familiar technology that is experiencing a boom. Let’s take a look at how this tech is changing the way we interact with the world.
Databases Pros and Cons of Using Snowflake Cloud Data Warehouse What are Snowflake’s pros and cons? Learn about Snowflake benefits, considerations, and more.
Databases AWS EC2 Monitoring With CloudWatch, SNS, Lambda & Slack Learn how to subscribe a custom Lambda function, that formats a slack message and makes a POST request to a slack channel.
Databases What is Amazon RDS? This guide provides an introduction to what Amazon RDS is, what this AWS service is used for, how to set up an RDS database.