transformation = client.transformations.retrieve(id=1)
transformation.query = "SELECT * FROM _cdf.assets"
res = client.transformations.update(transformation)

from cognite.client.data_classes import TransformationUpdate
my_update = TransformationUpdate(id=1).query.set("SELECT * FROM _cdf.assets").is_public.set(False)
res = client.transformations.update(my_update)

from cognite.client.data_classes import NonceCredentials
to_update = client.transformations.list(data_set_external_ids=["foo"])
new_session = client.iam.sessions.create()
new_nonce = NonceCredentials(
    session_id=new_session.id,
    nonce=new_session.nonce,
    cdf_project_name=client.config.project
)
for tr in to_update:
    tr.source_nonce = new_nonce
    tr.destination_nonce = new_nonce
res = client.transformations.update(to_update)

{
  "items": [
    {
      "id": 123,
      "name": "<string>",
      "query": "<string>",
      "destination": {
        "type": "assets"
      },
      "conflictMode": "abort",
      "isPublic": true,
      "createdTime": 123,
      "lastUpdatedTime": 123,
      "owner": "<string>",
      "ownerIsCurrentUser": true,
      "hasSourceOidcCredentials": true,
      "hasDestinationOidcCredentials": true,
      "externalId": "my.known.id",
      "ignoreNullFields": true,
      "blocked": {
        "reason": "<string>",
        "createdTime": 123
      },
      "sourceSession": {
        "clientId": "<string>",
        "sessionId": 123,
        "projectName": "<string>"
      },
      "destinationSession": {
        "clientId": "<string>",
        "sessionId": 123,
        "projectName": "<string>"
      },
      "lastFinishedJob": {
        "id": 123,
        "uuid": "<string>",
        "transformationId": 123,
        "transformationExternalId": "<string>",
        "sourceProject": "<string>",
        "destinationProject": "<string>",
        "destination": {
          "type": "assets"
        },
        "conflictMode": "abort",
        "query": "<string>",
        "createdTime": 123,
        "ignoreNullFields": true,
        "status": "Completed",
        "startedTime": 123,
        "finishedTime": 123,
        "lastSeenTime": 123,
        "error": "<string>"
      },
      "runningJob": {
        "id": 123,
        "uuid": "<string>",
        "transformationId": 123,
        "transformationExternalId": "<string>",
        "sourceProject": "<string>",
        "destinationProject": "<string>",
        "destination": {
          "type": "assets"
        },
        "conflictMode": "abort",
        "query": "<string>",
        "createdTime": 123,
        "ignoreNullFields": true,
        "status": "Completed",
        "startedTime": 123,
        "finishedTime": 123,
        "lastSeenTime": 123,
        "error": "<string>"
      },
      "schedule": {
        "id": 123,
        "externalId": "<string>",
        "createdTime": 123,
        "lastUpdatedTime": 123,
        "interval": "0 0 * * *",
        "isPaused": true
      },
      "dataSetId": 123,
      "tags": [
        "<string>"
      ]
    }
  ]
}