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

how to find dataType of all attributes in the dataSet

  • July 20, 2025
  • 1 svar
  • 217 visningar

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 ?

Det här ämnet har stängts för svar.

1 svar

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!