how to find dataType of all attributes in the dataSet | Community
Skip to main content
Pradeep-Jaiswal
Pradeep-Jaiswal
Level 5
July 20, 2025
Question

how to find dataType of all attributes in the dataSet

  • July 20, 2025
  • 1 reply
  • 215 views

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 ?

1 reply

S
supratim320
Level 5
July 23, 2025

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!

Terms & ConditionsAccessibility statement

Loading footer...