René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Ability to Create Engine From an Existing BigQuery Client","articleBody":"In situations where a user already has a `google.cloud.bigquery.Client` object, it'd be helpful to be able to create an sqlalchemy engine either using that already existing BigQuery client object or the same credentials used by that client. \r\n\r\nI'm poking around and one option would be something like\r\n\r\n```python\r\nbq_client: bigquery.Client\r\nengine = sqlalchemy.engine.create_engine(\r\n    'bigquery://project/?credentials_user_info_json=%s' % bq_client._credentials.to_json())\r\n```\r\nto create a client with the same credentials. This is unfortunately accessing a private `_credentials` attribute on the client. We might look to adding a public interface for this on the client so callers don't need to access `_credentials`.\r\n\r\nI was also looking at something like\r\n\r\n```python\r\nbq_client: bigquery.Client\r\nengine = sqlalchemy.engine.create_engine(\r\n  'bigquery://project', connect_args={'client': bq_client})\r\n```\r\nusing the [connect_args kwarg](https://docs.sqlalchemy.org/en/14/core/engines.html#sqlalchemy.create_engine.params.connect_args)\r\n\r\nThe problem is that the engine will still try to create the client itself even if it will end up being replaced by the one from `connnect_args`. That attempt to create the client by the engine may fail (we're assuming the big query client is created by some machinery that's opaque to the user here.) I'm not seeing a clean way to avoid this.\r\n\r\nAny other suggestions? I'm more than happy to work on this if it seems like a reasonable thing to support!","author":{"url":"https://github.com/waltaskew","@type":"Person","name":"waltaskew"},"datePublished":"2022-06-10T00:23:39.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/464/python-bigquery-sqlalchemy/issues/464"}