query_result = client.transformations.preview(query="select * from _cdf.assets")

df = client.transformations.preview(query="select * from _cdf.assets").to_pandas()

result = client.transformations.preview(query="select * from my_raw_db.my_raw_table", limit=None)
print(result.results)

result = client.transformations.preview(query="select * from my_raw_db.my_raw_table", limit=None, source_limit=None)
print(result.results)

{
  "schema": {
    "items": [
      {
        "name": "<string>",
        "sqlType": "<string>",
        "type": {
          "type": "<string>"
        },
        "nullable": true
      }
    ]
  },
  "results": {
    "items": [
      {}
    ]
  }
}