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

 

3 Replies

  • HamzaJ's avatar
    HamzaJ
    Data Integration

    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

  • 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.

  • 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.