René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Support `get_view_names`","articleBody":"**Is your feature request related to a problem? Please describe.**\r\nI would like to catalog tables and views of Spanner on OpenMetadata. To do so, I would like to extract metadata of not only tables but also views.\r\n\r\n- https://open-metadata.org/\r\n\r\n## Code to reproduce\r\n\r\n```\r\nfrom sqlalchemy import (\r\n    Column,\r\n    Integer,\r\n    MetaData,\r\n    String,\r\n    Table,\r\n    create_engine,\r\n    inspect,\r\n)\r\n\r\nurl = \"spanner+spanner:///projects/xxx/instances/xxx/databases/xxx\"\r\nengine = create_engine(url)\r\nmetadata = MetaData(bind=engine)\r\ninsp = inspect(engine)\r\n\r\ninsp.get_view_names()\r\n```\r\n\r\n## Error message\r\n\r\n```\r\nFile ~/anaconda2/envs/python3.9/lib/python3.9/site-packages/sqlalchemy/engine/reflection.py:412, in Inspector.get_view_names(self, schema)\r\n    404 \"\"\"Return all view names in `schema`.\r\n    405 \r\n    406 :param schema: Optional, retrieve names from a non-default schema.\r\n    407  For special quoting, use :class:`.quoted_name`.\r\n    408 \r\n    409 \"\"\"\r\n    411 with self._operation_context() as conn:\r\n--\u003e 412     return self.dialect.get_view_names(\r\n    413         conn, schema, info_cache=self.info_cache\r\n    414     )\r\n\r\nFile ~/anaconda2/envs/python3.9/lib/python3.9/site-packages/sqlalchemy/engine/interfaces.py:332, in Dialect.get_view_names(self, connection, schema, **kw)\r\n    326 def get_view_names(self, connection, schema=None, **kw):\r\n    327     \"\"\"Return a list of all view names available in the database.\r\n    328 \r\n    329     :param schema: schema name to query, if not the default schema.\r\n    330     \"\"\"\r\n--\u003e 332     raise NotImplementedError()\r\n\r\nNotImplementedError: \r\n```\r\n\r\n**Describe the solution you'd like**\r\nWe can implement `get_view_names`.\r\n\r\n**Describe alternatives you've considered**\r\nN/A\r\n\r\n**Additional context**\r\nI am working on the issue of OpenMetadata.\r\n- https://github.com/open-metadata/OpenMetadata/issues/4221\r\n","author":{"url":"https://github.com/yu-iskw","@type":"Person","name":"yu-iskw"},"datePublished":"2023-01-26T07:57:48.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/303/python-spanner-sqlalchemy/issues/303"}