Demo Asset Class Data Block

This block is intended for use with Assette’s demo Snowflake database and is typically used as a dependency in other Data Blocks or as a dynamic data source for a data setting within a Data Object.

The Demo Asset Class (DEMO_AssetClass) Data Block retrieves the available asset classes from the demo Snowflake database by querying the ASSET_CLASSES table. It returns a list of asset class IDs and names, sorted alphabetically by asset class name. This block is often leveraged by other Data Blocks or Data Objects to populate selection lists or drive logic based on asset class data.

General Info #

Field	Value
Block Name	DEMO_AssetClass
Block Category	Interface
Block Type	Snowflake Database Call
Output Type	Data Table
Editable	True
Description	Retrieves the available asset classes from Assette’s demo Snowflake Database by querying the ASSET_CLASSES table. This Data Block is usually used as a Data Block dependency or in a Data Object as a dynamic data source for a data setting.

Columns #

None

Request Parameters #

None

Dependencies #

Data Block	Description
DEMO_SnowFlakeSettingBlock	The Demo Snowflake Setting Data Block is used to facilitate access the Assette Demo Snowflake Data Warehouse by providing values for ‘user’, ‘account’, ‘warehouse’, etc. This Data Block must be edited or removed as dictated by the client’s data needs. [Link]

Definition #

{
  "type": "table",
  "sql": "SELECT ASSETCLASSID, ASSETCLASSNAME FROM DEMO_DB.DBO.ASSET_CLASSES ORDER BY ASSETCLASSNAME",
  "parameters": []
}

Example Request #

{}

Example Response #

The following code shows an example response using the default values of the Data Block. The response may be shortened for brevity.

{
    "data": [
        {
            "ASSETCLASSID": 1,
            "ASSETCLASSNAME": "Cash and Equiv."
        },
        {
            "ASSETCLASSID": 3,
            "ASSETCLASSNAME": "Equities"
        },
        {
            "ASSETCLASSID": 2,
            "ASSETCLASSNAME": "Fixed Income"
        }
    ],
    "errors": [],
    "success": true,
    "logs": [],
    "sources": []
}