Best way to get list of tables in parser/schemas.py

[yang6n]

Hi, there!
I am trying to do POC on the dynamic source - dynamically list the tables from the database, and "register" them as the sources.
In order for me to do that, I need to get the list of table names in parser/schemas.py.

Any suggestions on accessing the Connection object to get the table names?

[yang6n]

After some reading, looks like the get_adapter should be the best option for this.

        adapter = get_adapter(self.root_project)
         with adapter.connection_named("dynamic_sources"):
             schema_relation = BaseRelation.create(
                 schema = source.schema
             )
             relations = adapter.list_relations_without_caching(schema_relation)