Learning What Is Data Extraction? Definition, Tools, Techniques & More Zuar covers data extraction concepts including the data extraction process, extraction types, tools, 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!
Database/Cloud Reverse ETL vs. ETL vs. ELT: Key Differences & Use Cases Learn about the key differences between ETL, ELT, and Reverse ETL and how they can be leveraged in your data integration strategy.
Database/Cloud What is Modern Data Architecture? See what modern data architecture looks like, its pillars, cloud considerations, simplifying with an end-to-end data pipeline solution, and more!
Learning Data Ingestion: Types, Pipelines, Tools & More Learn about data ingestion tools and methods, and how it all fits into the modern data stack through ETL/ELT pipelines.
Database/Cloud What is Google Bigtable? Learn all about Google Bigtable including what kind of database it is, how Bigtable works, popular use cases, and frequently asked questions.
Database/Cloud 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 Integration Patterns Explained Learn about the top 5 most common data integration patterns: data migration, broadcast, bi-directional sync, correlation, and aggregation.
Database/Cloud 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.
Database/Cloud 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.
Database/Cloud 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.
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.
Database/Cloud What is Google BigQuery? Learn the basics of Google BigQuery including features and functionality, SQL examples, the architecture, and more.
Learning What is Google Cloud Dataflow? Learn the concepts of Google Cloud Dataflow, how it executes data pipelines, its data sources and sinks, and its functionalities/limitations.
Database/Cloud BigQuery Cheat Sheet Use this cheat sheet to quickly reference some of the most common Google BigQuery commands, expressions, data types, and more.
Database/Cloud 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.
Database/Cloud How to Load Data From an Amazon S3 Bucket Into Redshift See how to load data from an Amazon S3 bucket into Amazon Redshift. We’ll cover using the COPY command to load tables in both singular and multiple files. with some options available with COPY that allow the user to handle various delimiters, NULL data types, and other data characteristics.
Database/Cloud Amazon Redshift Cheat Sheet Questions about Redshift? We're providing answers to the questions we often get from Redshift users and admins.
Data Pipeline The NetSuite API: Exploring SOAP Requests Learn new ways to work with NetSuite's SuiteTalk Web Services Platform to gain access to customer data for subsequent transformation, enhancement, and presentation.
Database/Cloud The Types of Modern Databases Aren’t sure which modern database is right for your organization? Zuar explores the different database models and their benefits.
Embedded Analytics Tableau Dashboard Actions: Use-Cases, Examples, and Functionality Tableau dashboard actions can greatly improve your user experience. See how to set them up, some great use cases, and how to resolve common problems!
