Delete root asset along with its children

Thanks for the inputs @Jason Dressel . It helped!

Please could you guide on how to add the new creation of asset and hierarchy with a dataset that I already created. When I run the code, it creates the assets and hierarchy but doesn't update them all in my dataset. Dataset is still empty. 

# Code to create the LP -Classes and store the meta-data

import pandas as pd
from cognite.client import CogniteClient
from cognite.client.data_classes import Asset

csv_file = "lpm_asset_hierarchy.csv"
df = pd.read_csv(csv_file)

client = CogniteClient()

def create_asset(asset_name, description, dataset_id,lims_prefix=None, weight=None,pid = None):
    metadata = {
        "LIMS_Prefix": lims_prefix if pd.notna(lims_prefix) else 'NA',
        "Weight": weight if pd.notna(weight) else 0
    }
    asset = client.assets.create(
        Asset(name=asset_name, description=description, metadata=metadata,parent_id=pid)
    )
    return asset

dataset_id = 6572524964198398
root_asset = create_asset("LPM_YT_MODEL", "Root Asset", dataset_id)




for index, row in df.iterrows():
    asset_name = row["LPM_class_code"]
    description = row["Description"]
    lims_prefix = row["LIMS_Prefix"]
    weight = row["Weight"]

    create_asset(asset_name, description, dataset_id, lims_prefix, weight,root_asset.id)

print("Assets with metadata created successfully!")

Assuming you have the ID of your data set, it can be specified on asset instantiation:

a1 = Asset(name=.., data_set_id=123)

Another tip is the create_hierarchy method which simplifies the creation of asset hierarchies (will insert in correct topological order for you). It also supports upserting 👌

Thanks @Håkon V. Treider . Is there a way to delete the dataset I created in SDK?

In the script above, I manually created a dataset from UI and then used the ID to add in the asset hierarchy script. 

I want to delete the dataset and create a new dataset in the script itself (with name and description) and then attach all the assets to the newly created dataset. 

I am unable to delete the dataset that i created manually. Please help.

@eashwar11 you can only archive datasets, there is no such possibility to remove them. This is due to the fact that data access rights can be determined by the dataset, and when it is deleted, a situation may arise when it is impossible to delete the data.