include_tables not including tables in non dbo object

[nishantpandey107]

I am connecting to SQLServer.
while creating db object from SQLDatabase, i am including some tables name which are not under [dbo] object. but it's not accepting

i tried following
db = SQLDatabase(engine, include_tables=[''], sample_rows_in_table_info=5)
db = SQLDatabase(engine, include_tables=[''][''], sample_rows_in_table_info=5)

none of the combination working.
if I don't include "include_tables", it's including all the tables in dbo schema, but none from non-dbo schema

[dosubot[bot]]

🤖

Hello,

To include non-dbo schema tables when creating a db object from SQLDatabase in LangChain, you need to specify the schema name when initializing the SQLDatabase object. The schema parameter in the __init__ method of the SQLDatabase class is used to specify the schema of the tables you want to include.

Here is an example of how you can do this:

from sqlalchemy import create_engine
from langchain.utilities.sql_database import SQLDatabase

engine = create_engine('your_database_uri')
db = SQLDatabase(engine, schema='your_schema_name')

In this example, replace 'your_database_uri' with the URI of your database and 'your_schema_name' with the name of the schema you want to include.

The SQLDatabase class in LangChain does support the inclusion of tables from non-dbo schemas. This is evident from the __init__ method of the SQLDatabase class where the schema parameter is used. The schema parameter is optional and defaults to None, but if provided, it will be used to specify the schema for the database operations.

Moreover, in the _execute method, if the schema attribute is not None, it sets the search path or dataset id to the specified schema based on the dialect of the SQL engine. This ensures that the SQL commands are executed in the context of the specified schema.

I hope this helps! If you have any other questions, feel free to ask.

Best,
Dosu

Sources

• libs/langchain/langchain/utilities/sql_database.py

---

This response is meant to be useful and save you time. It is not meant to be a precise solution, but rather a starting point for your own research.

Help me be more useful! Please leave a 👍 if this is helpful and 👎 if it is irrelevant.

If you want to continue the conversation, start your reply with @dosu-bot.

[nishantpandey107]

Thank you for response .. this is exactly what I was looking for.