how to find dataType of all attributes in the dataSet

[Pradeep-Jaiswal]

SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_name = 'table_name';

Above query only gives dataType at root level. but how do we find dataType of each attribute in the dataSet ?

[supratim320]

Hi @Pradeep-Jaiswal ,

Instead of sql, try this: Look up a dataset: url

In the query parameter `properties` use the value as: "observableSchema" - it will retrieve all the fields and their data types in nested format.

Hope it helps!