How to Perform Union In Snowflake (Disparate Tables with Diverse Structures)
There may be times when you need to merge data from different tables with diverse structures or schemas. For instance, two tables might store customer information, but one ...
- Ndz Anthony
- May 17, 2023
A Step-by-Step Guide to Connect Excel to Snowflake
This article will guide you through the steps to connect Excel to Snowflake and get you on your way to becoming a data analytics pro. Snowflake is a cloud-based data wareho...
- Jeffrey Agadumo
- March 10, 2023
Excel Data Transformation: A How-To Guide For Smarter Results
This article outlines methods and tools for Excel data transformation and provides a pictorial guide for each technique or tool listed. Excel is famous for organizing, form...
- Jeffrey Agadumo
- February 14, 2023
A practical guide to importing data from Snowflake to Power BI
In this article, we will guide you through a step-by-step guide on how to connect Power BI to Snowflake. The Snowflake Data Cloud is an advanced, industry-leading data plat...
- How-Tos FAQs
- November 10, 2022
How can I query my staged data in Snowflake?
In this article, we are going to look at how to query staged data in Snowflake and what ways we can use Snowflake to tackle this as well as answer the following: How can I ...
- How-Tos FAQs
- October 26, 2022
How to Bulk Copy Your CSV into Snowflake
This article will discuss 3 primary ways to bulk copy your CSV into Snowflake. If you’re a Snowflake user, there’s a high chance you may have come across requirements for b...
- How-Tos FAQs
- October 17, 2022
Migrate Data from Google BigQuery to Snowflake in Minutes
If you’re looking for an easy way to migrate data from Google BigQuery to Snowflake, look no further! The Migration Service from Snowflake can help you get your data ...
- How-Tos FAQs
- October 11, 2022
Dealing with Variant Columns in Snowflake
There are many ways to store data in Snowflake, and one of the most flexible is to use variant columns. Variant columns can store any type of data, including arrays, object...
- How-Tos FAQs
- September 22, 2022
Loading Data into Snowflake with Efficiency
Let’s pretend you are in charge of running a weekly survey about the impact of COVID on people’s day-to-day lives and analyzing the results of the data. All the information...
- How-Tos FAQs
- November 23, 2021
Add identity or autoincrement to table in Snowflake
In this tutorial, we will look at two different ways to add an autoincrement or identity column to an existing table in Snowflake. We will also discuss the limitations and ...
- How-Tos FAQs
- November 22, 2021
How to use subqueries and table expressions in Snowflake
In this tutorial, you will learn how to use subqueries and common table expressions in Snowflake. We will also discuss where and when to use each. Lastly, we will touch on ...
- How-Tos FAQs
- November 22, 2021
Is there a template database for BI about sales and inventory in Snowflake?
Leverage the Snowflake marketplace to find a template database for BI about sales and inventory in Snowflake Answer: Yes, there is. The Snowflake marketplace, a part of the...
- How-Tos FAQs
- October 17, 2021
