# SQL - Like with API connector

**URL:** <https://visier.discourse.group/t/sql-like-with-api-connector/405>\
**Category:** Data Export API\
**Tags:** new\
**Created:** [February 16, 2026, 7:09pm UTC](https://visier.discourse.group/t/sql-like-with-api-connector/405 "2026-02-16T19:09:03Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Loutfi](https://avatars.discourse-cdn.com/v4/letter/l/c57346/32.png) [@Loutfi](https://visier.discourse.group/u/Loutfi)\
**Post date:** [February 16, 2026, 7:09pm UTC](https://visier.discourse.group/t/sql-like-with-api-connector/405/1 "2026-02-16T19:09:03Z")

</div>

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.

Thanks for any guidance you can provide.

---

<div class="post-metadata">

**Author:** ![vincent.chu.visier](https://avatars.discourse-cdn.com/v4/letter/v/e95f7d/32.png) [@vincent.chu.visier](https://visier.discourse.group/u/vincent.chu.visier)\
**Post date:** [February 16, 2026, 10:21pm UTC](https://visier.discourse.group/t/sql-like-with-api-connector/405/2 "2026-02-16T22:21:28Z")

</div>

Hi Loutfi,

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.

Does that help?

Thanks,

Vincent