how to find dataType of all attributes in the dataSet | Adobe Higher Education
Skip to main content
Pradeep-Jaiswal
Level 5
July 20, 2025
Pregunta

how to find dataType of all attributes in the dataSet

  • July 20, 2025
  • 1 respuesta
  • 215 visualizaciones

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 respuesta

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!