Get the details of Liveboard formuals

[Subhransuusa]

Hi Team. Can you please guide on how we can get the liveboard formulas created by user using CSTOOL. i heard it came part of v1.6.
But i am not sure how i can see those formulas.

[TS-Apratim]

Hey @Subhransuusa ,

• You can use the searchable tml command here. The command would be :

cstools tools searchable tml --config --metadata-type LIVEBOARD --syncer csv://directory="<your_directory_path>"

• You will receive a CSV output which will contain all the user formulas in the liveboards.

• To parse this csv further, we can write a script to retrieve only the formulas for the particular liveboards / guids.

• To see the list of all the flags / parameters that you can use for searchable tml, please use the command : cstools tools searchable tml --help

[Subhransuusa]

i want to see liveboard formulas in one separate column

[TS-sumeet-jain]

You can create a sql view over the TML table. I have included a simple sample for the sql view:

WITH base AS (
SELECT
CLUSTER_GUID,
ORG_ID,
OBJECT_GUID,
TRY_PARSE_JSON(TML_BLOB) as parsed_json
FROM CSTOOLS.TS_METADATA_TML
) SELECT
base.CLUSTER_GUID,
base.ORG_ID,
base.OBJECT_GUID,
-- TO PARSE ON NEXT LVL
v.value:answer:formulas as FORMULAE,
FROM
base,
LATERAL FLATTEN(input => parsed_json:liveboard:visualizations) v