I'm trying to launch a create table query onto a SQL DB and I want to use the Dataiku Python API package to do that;
I tried the following:
executor = SQLExecutor2(connection=cInfo['connectionName'])
x = executor.query_to_df('create table X(var1 int); select 1 as ready;')
I couldn't find a method in the package that let me run a query on a server without expecting a return value.
I'm looking for something on the lines of execute with the pyodbc python package, if its available.
Thanks in advance,