Error: Output Data (4): Error SQLColAttribute(Numeric): ODBC_DuckDB

[simonaubert_bd]

Hello All,

I try to write some records in a duckdb database.

here my configuration :

At the beginning the database does not exist :

The error I get :

Input :

The database is created but not useable

Any idea ?

Best regards,

Simon

[mceleavey]

Hi @simonaubert_bd ,

have you mapped all tables in the Output tool? Of all the tables that are mapped (you must ensure they are all present even if they are not being used) they must all be the corresponding type. For example, ensure that all numeric fields in the DB are a numeric data type in the workflow etc.

In the output you are creating the schema in a pre-SQL statement, this will determine the data types I presume? If you are creating the schema here, then ensure you are creating the types for each column in an Alteryx supported format, such as numeric fields being a double etc.

M.

[simonaubert_bd]

Hello @mceleavey 

It's a new table and a new schema so I'm not sure to understand of which mapping you refer to?

Best regards,

Simon