Hello! Is there a way to register a temporary table but using Avro Schema?

you can check the list of the connectors that support avro here.

Ideally what I want is to be able to populate the catalog with tables that are going to be consumed using Flink CDC, so register those tables using the Avro Schemas and then post the additional options for the Flink CDC Connector