Forum Discussion

john2ll's avatar
john2ll
Data Storage
01-22-2025

get all cubes, tables and it's respective row count

Hi Guys,I'm new to sisense and I was trying to get a list of all the cubes,all underlying tables, respective row counts, column names and the datatype.

I'm trying to hit endpoint to get the relevant data but it is having too much data which is not needed.

url - https://siense.com/api/v2/datamodels/schema

 

Developers

3 Replies

  • HamzaJ's avatar
    HamzaJ
    Data Integration
    01-23-2025

    Hey john2ll ,

    Almost every sisense endpoint has the query parameter fields and limit. With fields you can choose the fields you want to be shown and with limit the amount of results. This should help you create a more smaller dataset

    Hamza

  • DRay's avatar
    DRay
    Admin
    02-04-2025

    Hello john2ll,

    I’m following up to see if the solution offered by HamzaJ worked for you.

    If so, please click the 'Accept as Solution' button on the appropriate post. That way other users with the same questions can find the answer. If not, please let us know so that we can continue to help.

    Thank you.

  • DRay's avatar
    DRay
    Admin
    02-10-2025

    Hi john2ll,

    There is an API based solution that we can help with. If we provide the steps are you comfortable executing it? If not, we can connect you with a resource who can help.

    Please let us know.

    Thank you.