Datameer Blog

Tag: SQL

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

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.  Th...

  • 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 ...

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

How to perform an 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
SQL FAQ Feat

How to convert month number to month name in SQL and Snowflake

There is not a built-in function to convert month number to month name in SQL. But we can use the combination of a few different date functions to achieve this. Different d...

  • How-Tos FAQs
  • December 17, 2020
SQL FAQ Feat

How to initialize an AUTO_INCREMENT column in MySQL

The value of AUTO_INCREMENT can be reinitialized using the below methods. ALTER TABLE… AUTO_INCREMENT TRUNCATE TABLE Let us consider the table below. CREATE TABLE student (...

  • How-Tos FAQs
  • February 1, 2019
SQL FAQ Feat

How to add an IDENTITY to an existing column in SQL?

There is no straightforward way to add IDENTITY to an existing column. We need to follow a series of steps to achieve this. There are two ways to do this. Creating New Tabl...

  • How-Tos FAQs
  • February 1, 2019
snowflake faq

How to get only the DATE part from the DATETIME in SQL Server and Snowflake

Follow along for a few different methods on how to get only DATE from the DATETIME in SQL Server 1. A Low-Code Method Using Datameer (On Snowflake) Wondering if there is a ...

  • How-Tos FAQs
  • February 1, 2019
SQL FAQ Feat

How to escape a single quote in SQL Server?

The most simple way to escape a single quote in SQL Server is to pair it with another single quote. Below are some examples: -- For selecting: [My name's Jack.] SELECT 'My ...

  • How-Tos FAQs
  • February 1, 2019
SQL FAQ Feat

How to create an AUTO_INCREMENT column in a table on Oracle DB using SQL?

Before Oracle 12c, we don’t have a direct method of generating an AUTO_INCREMENT column in a table. We need to use the combination of Sequences and Triggers. Now, we have t...

  • How-Tos FAQs
  • February 1, 2019