community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

MySQL json Data Type Field error: unknown ODBC column datatype

Bolide
Bolide

Has anyone successfully pulled data from MySQL 5.7 Database with a json datatype field?

 

I'm getting the following response whenever I select to retrieve a json datatype field:

Error: Input Data (1): The Query "Select mslog.* From mslog" had an unknown ODBC column datatype

 

I have the newest ODBC driver (8.0) installed which should work for all 5.5+ versions of mysql and I've tested the connection on 11.7 and 2018.3.

 

Thanks!

Alteryx
Alteryx

Hi @jarrod 

 

Based on a MySQL forum article, the ODBC driver for MySQL has very limited support for JSON, How do I access JSON datatype from ODBC?.

 

Maximum size limitations may be an issue, for details please see: Alteryx Online Help MySQL

 

Here is an article about converting between JSON and non-JSON values. Casting the JSON values as another datatype may be a workaround.
The JSON Data Type

Bolide
Bolide

Thanks @EricWe 

 

I've switched the field types to text for the time being and will just parse the JSON after i pull in the data. (i'm not concerned about querying the data directly - only need to pull in the json so i can analyze further)

 

Thanks!! hopefully we will see improved JSON handling as a data type soon :)

Labels