Best practices for modifying stream schema with Octavia

[alexchao]

We're using the Octavia CLI to keep our airbyte source, destination, and connection configurations version controlled as YAML. In the configuration for one of our mongodb-to-postgres connections, there are some fields in the stream schema whose data type I'd like to update (airbyte identified the field as a string field, but I'd like to add format: date-time to the definition).

However, I noticed that in at least one place (this tutorial: https://airbyte.com/tutorials/version-control-airbyte-configurations), it is advised not to edit the streams.stream part of the sync_catalog:

ONLY edit streams.config, streams.stream should not be edited as schema cannot be changed.

I'm wondering then what the recommended workflow would be for making such updates to the stream schema. I've found that making changes in the streams.stream portion of the YAML file and then applying with octavia apply does in fact achieve the desired effect, but if it's not the recommended method, then I'm wondering what is. I so far haven't found a way to make these changes through the Web UI (i.e. for one of my Full Refresh / Overwrite streams, I cannot toggle individual fields, add new fields, or change their data type), and even if the Web UI was an option, I'm wondering whether I should then export the configuration as YAML for version control.

Apologies in advance if I've missed some documentation on this topic.

Example of a change I'd like to make:

# Partial configuration.yaml
definition_type: connection
resource_name: MongoDb <> Postgres
source_configuration_path: sources/mongodb/configuration.yaml
destination_configuration_path: destinations/postgres/configuration.yaml
configuration:
  sync_catalog:
    streams:
      - stream:
          name: somestream
          json_schema:
            type: object
            properties:
              uploadedAt:
                type: string
+               format: date-time
              foo:
                type: string
              bar:
                type: string