Hello all, I’m trying to figure out if there is some way to determine what types of columns a given data source contains. It looks like this should exist in the INFORMATION_SCHEMA somewhere, but I’m not clear how to do it.
For instance, let’s say that I have a file called data.json. I could execute: SELECT * FROM dfs.`data.json` LIMIT 0 and get the column names, but is there some way to get at the data types for these columns? TIA, — Charles