Datameer Blog

Tag: Data Transformation

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 usecases

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

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