Learning A Basic Crontab Tutorial Guide for Beginners Learn how to use crontab for cron jobs in Linux and other operating systems. Schedule reoccurring activities, automate repetitive tasks, etc.
Embedded Analytics Implementing Trusted Tickets For Tableau Server With NodeJS This article shows how to implement trusted tickets, as described in Trusted Ticket Authentication with Tableau Server. We'll build a ticket broker with a simple API called by a front-end that
Learning Data Cleaning: Benefits, Steps and Using Clean Data This article discusses data cleaning, its benefits, and how to create and use clean data.
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.
Embedded Analytics Access Your Tableau Analytics From Anywhere, Even Without a VPN Whether you are having to make tough decisions about your business or experiencing high demand and growth, data driven decision making should become a top priority for any business that is navigating a volatile market.
Embedded Analytics Embedded Analytics: SAML SSO with Tableau Cloud and Okta Implement single sign on (SSO) for Tableau Online with security assertion markup language (SAML) identity provider (IdP) Okta.
Embedded Analytics Embedded Analytics: SAML SSO With Tableau Cloud & OneLogin Implement single sign-on for Tableau Online with SAML & IdP OneLogin. And create a simple application that embeds a Tableau dashboard into a webpage.
Database/Cloud The Straightforward Guide to Data Warehouse Design Do you need assistance with your data warehouse design? Zuar provides a few tips to help with this process.
Database/Cloud MariaDB vs. MySQL Trying to choose a DBMS? Learn the differences between MariaDB and MySQL. Zuar compares and contrasts these two database management systems.
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 ETL vs ELT: What's the Difference? At Zuar, we advocated using ELT instead of the more traditional ETL due to the ease of eliminating errors and auditing data with ELT. Here's why...
Database/Cloud Should You Build Your Own Data Pipeline? What is a data pipeline? Data pipelines are systems that pull in data points from different sources and consolidate them into a streamlined repository for analysis and modeling. Your data pipeline could be
Learning What Is a Data Pipeline and How to Build One Data pipelines enable the smooth flow of information. They automate the process of extracting, validating, and loading the data for analysis. This helps eliminates errors and combats latency. Effective data pipelines are critical for data-driven enterprises.
Database/Cloud SQL Indexes: A Practical Guide SQL indexes aid in the execution of a query when conditions are placed in the query. Learn more about this useful tool.
Database/Cloud Snowflake Cheat Sheet Answers to common Snowflake.com questions from users and account admins.
Database/Cloud NoSQL & SQL Injection Attacks in MongoDB Understand MongoDB vulnerabilities to SQL and NoSQL injection attacks. Hint: injecting JSON code into a MEAN app! See how to protect your databases.
Postgres: Filter an aggregation without the WHERE clause Turns out you can filter aggregations in PostgreSQL outside of the WHERE clause.
Database/Cloud PostgreSQL vs MySQL: When to Use and How to Choose PostgreSQL and MySQL are both well-known powerhouse database management systems (DBMS). While both are fantastic, you still have to determine which is best for your specific needs. This article compares the differences between PostgreSQL and MySQL.
Database/Cloud Loading Flat Files Into a Database For Analytic Insights At Zuar, we encounter all sorts of file formats and structures out in the real world. Although they may seem simple to work with, flat files can often create interesting situations to overcome.
Database/Cloud Data Mart vs Data Warehouse vs Database vs Data Lake Not sure whether to invest in a data mart, data warehouse, database or data lake? Let's examine the key differences.
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 in 2026: A Complete Guide for the AI Era Aren’t sure which modern database is right for your organization? Zuar explores the different database models and their benefits.
Database/Cloud How to Design a Database Schema, With Examples Learn how to design a database schema, best practices, examples, naming conventions, security concerns, and the 6 common types of database schemas.
Database/Cloud What’s the Difference Between SQL & NoSQL How do you know if a SQL or NoSQL database is the right choice for your business? First, let’s touch on what these two databases actually are. * SQL databases are relational. The
Database/Cloud SNOWFLAKE HOW TO: Create Date Dimensions Table, Calendar Table, Date Scaffold, or Date Spine Learn how to create a Date Dimensions or Calendar Table, also known as a Date Scaffold or Date Spine.
