```yaml copy
kind: transformer
spec:
  name: "basic"
  path: "cloudquery/basic"
  version: VERSION_TRANSFORMER_BASIC
  spec:
    transformations:
      - kind: obfuscate_columns
        tables: ["xkcd_comics"]
        columns: ["safe_title", "title"]
      - kind: obfuscate_sensitive_columns
      - kind: remove_columns
        tables: ["xkcd_comics"]
        columns: ["transcript", "news"]
      - kind: add_column
        tables: ["xkcd_comics"]
        name: "source"
        value: "xkcd"
      - kind: add_primary_keys
        tables: ["xkcd_comics"]
        columns: ["_cq_source_name"]
      - kind: add_current_timestamp_column
        tables: ["xkcd_comics"]
        name: "_record_processed_at"
      - kind: change_table_names
        tables: ["*"]
        new_table_name_template: "cq_sync_{{.OldName}}"
      - kind: rename_column
        tables: ["xkcd_comics"]
        name: img
        value: img_url
      - kind: uppercase
        tables: ["xkcd_comics"]
        columns: ["title"]
      - kind: lowercase
        tables: ["xkcd_comics"]
        columns: ["title"]
      - kind: drop_rows
        tables: ["xkcd_comics"]
        columns: ["year"]
        value: "2023"

```