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.
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.
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.
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.
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 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 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.
Databases Amazon Redshift Cheat Sheet Questions about Redshift? We're providing answers to the questions we often get from Redshift users and admins.
Netsuite 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.
Databases 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.
Tableau 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!