Datameer Blog

Tag: SQL

Should You Learn to Code for Data Analytics? – Code vs. No Code

A lot of people automatically associate data analytics with coding. Is this union still ‘legal’ in 2024? We know that the demand for data-driven insights will continue to r...

  • Jeffrey Agadumo
  • February 20, 2024

How to Auto-Generate Snowflake SQL

Snowflake is a data platform and data warehouse that supports ANSI SQL, which is the most widely used standardized version of SQL. This means you can harness Snowflake SQL ...

  • Ndz Anthony
  • June 12, 2023
SQL Best Practices

SQL best practices in Datameer

Companies everywhere face the same challenge: using data analytics for better decision-making. Enter Datameer — a powerful tool that gives hardworking data teams the ...

  • Stephen Butts
  • May 22, 2023
Visualizing SQL

How visualizing your SQL dependencies helps data teams more efficiently code

Visualizing SQL dependencies can assist in writing efficient code. With complex modern data architectures, it can be difficult to comprehend the connections between various...

  • Stephen Butts
  • May 19, 2023

When to use SQL, when to use No Code

Are you struggling to decide when your data team should use SQL or “no code” for data analysis? With the no-code revolution taking the tech world by storm, it c...

  • Stephen Butts
  • April 14, 2023

Snowflake Data Types vs Other Database Systems: A Comparative Analysis

In this piece, we’ll examine Snowflake’s data types in detail and see how they stack up against those of other databases. Identifying the best data management system for yo...

  • Ndz Anthony
  • March 24, 2023

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

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 vs. SQL

Low code vs SQL: What transforms data faster?

Datameer No-code vs SQL The scale, flexibility, and cost-efficiency of cloud data warehouses, such as Snowflake, give organizations an agile infrastructure. With this, they...

  • John Morrell
  • November 30, 2021

Datameer Offers Innovative New SaaS Data Transformation Solution

Our team here at Datameer is proud to announce that we are offering an innovative new SaaS Data Transformation Solution for Snowflake.  The new solution offers an innovativ...

  • John Morrell
  • October 8, 2021
snowflake faq

How to use IF condition in SQL SELECT statement in Snowflake

In SQL Server, we have below 3 options to implement IF condition in SQL SELECT statement in Snowflake An easy-peasy no-code method using Datameer 😁. CASE WHEN… THEN IIF Le...

  • How-Tos FAQs
  • September 1, 2021
alteryx FAQ

How to perform a SQL query in Alteryx

In the following article, we will look at how to perform an SQL query in Alteryx. SQL is the standard language to execute queries on a relational database that are not stor...

  • How-Tos FAQs
  • July 25, 2021