Is there a way to view all the columns that make up a specific subject. For example when using SQL like, and plan to run top 10 records against subject “Employee” to view all the column in the table, i can’t just simply type
query = 'SELECT top 10 * FROM Employee’
This will help determine what to query on while using SQL-Like inside the API connector script and be able to reference the field I need.
I am also open to other solutions that can get me there.
That’s a great question.
Employee subject has hundreds of properties / columns. While there isn’t a way to “select *” directly, if you’re using Studio, you can see which properties has data loaded and select those particular properties/columns.
Alternatively, you can also first retrieve that information through the API. For example, /v1/data/model/analytic-objects/employee/properties would allow you to see what properties are available.