change data type

No problem @alrz, and I’m glad to hear the DB SQL Executor worked for you.

There are a few places with some tips:

The primary KNIME DB extensions documentation is here: KNIME Database Extension Guide

This post may be useful as it mentions DML (e.g. queries) and DDL (the other stuff!) statements

You could also do worse than to read some of @mlauber71 's excellent posts on the subject, such as this article on Medium

I hope that helps, and welcome to KNIME.

2 Likes