Dynamic Datasource creation

Good afternoon. Is there a way to create a datasource “on-the-fy”? Like a SQL – CREATE DATABASE or CREATE TABLE? Each of our datasources have the same schema but are pulling data from different sources and will have many million rows for each datasource. Instead of modifying the Injestion Spec and re-starting we need to be able to create a new datasource dynamically.

Thank you,