How do we set the schema that a table lands in when connecting an MSSQL Server source to a Snowflake or Redshift destination? I have normalization turned on and it is currently ignoring the schema that is set in the destination for each of the above listed Destinations and instead mirroring the schema assignments from the Source. i.e. if there is database.analytics.communication in the source it will land in <Destination database>.analytics.communication so it keeps the database, but ignores the schema attribute

Did you adjust the namespace settings in the connection page? it seems like you have it set at the default value mirror source schemas https://docs.airbyte.io/understanding-airbyte/namespaces#mirror-source-structure

Just realized I had that functionality so this is working now. Thanks for checking in!