in airbyte connection setup, we declare the source and destination, in that while declaring thesource we are supposed to decalre the source database, source schema, and the target table, now if I keep on changing the source database repeatedly and trigger the connection, then the connection would work well, taking the new source databse table correctly, or it is not recommended

In Airbyte, when you set up a connection, you specify the source database and schema. If you change the source database or schema after setting up the connection, you would need to update the connection settings in Airbyte to reflect these changes. If you rename a table in your source database after you've started syncing it via Airbyte, the connector will not continue syncing that table until you reset your connection schema and select it again. This is because there is no way for the source database to inform Airbyte about the renamed tables. Similarly, if you delete a table that was previously syncing, the connector will stop syncing it [[source](https://docs.airbyte.com/integrations/sources/airtable#note-on-changed-table-names-and-deleted-tables)]. For schema changes, Airbyte has a feature called "Detect and Propagate Schema Changes". If the connection is set to "Detect any changes and manually approve" schema changes, Airbyte continues syncing according to your last saved schema. You need to manually approve any detected schema changes for the schema in the destination to change [[source](https://docs.airbyte.com/using-airbyte/schema-change-management#review-detected-non-breaking-schema-changes)]. Therefore, frequent changes to the source database or schema are not recommended as they would require manual intervention to update the connection settings in Airbyte. It's best to finalize your source database and schema before setting up the connection in Airbyte.