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
Data Catalog Use Cases to Accelerate Data Transformation Decisions
Are you looking to make smarter, faster decisions when it comes to data transformation? Of course you are — who isn’t in the modern data age? Worry no more. A well-ma...
- Stephen Butts
- March 1, 2023
Data Wrangling for Data Analysis: How Clean Data Can Improve Your Analysis Results
This article will discuss data wrangling, why it’s essential, and the prevalent differences between data wrangling and analysis. I remember trying to solve Rubix puzz...
- Ndz Anthony
- January 26, 2023
dbt Snowflake: When dbt Isn’t The Best Tool for Your Analytics
This article explores the features of dbt in data transformation, the dbt-Snowflake integration, and when dbt might not be the best tool for the job. If you’re a data pract...
- Jeffrey Agadumo
- December 28, 2022
Ad-hoc Analytics Requiring 100+ Lines of Complex SQL? No-code Tools to the Rescue
When repeatable reports are produced, SQL is used to combine the data into the right data model, and the query is continuously reused when the report is generated. Hence, ...
- John Morrell
- August 7, 2022
How Great Data Documentation Helps Your Analytics Process
Data documentation is a new term used to describe the capture and use of information about your data. It is used mainly in the context of data transformation, whereby data...
- John Morrell
- August 5, 2022
Benefits of No-Code Tools to the SQL Data Engineer
The market for no-code tools is growing dramatically. Whether in mobile development, application development, digital transformation, process re-engineering, or other area...
- John Morrell
- July 6, 2022
Datameer Product Update – July 2022
Datameer has released its latest version of its flagship platform – Datameer SaaS for data transformation. This new release includes numerous new features for transf...
- John Morrell
- July 6, 2022
The Future of Data Engineering is No-Code
Talent shortages, a disintegrated modern data stack, and a continued programmatic approach to data engineering processes continue to hinder data engineering processes and d...
- John Morrell
- May 6, 2022
Large-Scale Pivot Tables in Snowflake with Datameer
Pivot tables are an everyday operation all Excel users perform. Business analysts using Excel will often Pivot their data to explore it, see how results are different as s...
- John Morrell
- February 28, 2022
Snowpark for the Scala and Python developers; Datameer, for the rest of us.
In June of 2021, Snowflake introduced Snowpark, a new dataframe style developer experience for Snowflake. In the November edition of Snowdays, Snowflake provided a preview...
- John Morrell
- February 14, 2022
