Pipeline to load data from python to mysql

Python Help
1

I am going to build the pipeline to load data from python to mysql but there is error

> enginesa = create_engine(f'mysql://{db_params["user"]}:{db_params["password"]}@{db_params["host"]}/{db_params["database"]}', connect_args={'options': '-csearch_path={}'.format("sa")})
>     enginedw = create_engine(f'mysql://{db_params["user"]}:{db_params["password"]}@{db_params["host"]}/{db_params["database"]}', connect_args={'options': '-csearch_path={}'.format("dw")})

TypeError: Connection.init() got an unexpected keyword argument ā€˜optionsā€™

Please help!
Python Help

2

The error seems to be explained succinctly in the message: the value youā€™re passing to connect_args includes the key options, which is not a valid keyword for Connection.__init__() (presumably, connect_args is getting passed into that).

Without any other details, itā€™s hard to say more. What packages are you using here? Where did create_engine come from?

3

Thanks for your reply.

I used from sqlalchemy import create_engine, text
and tried many different ways to fix this issue

pip install sqlalchemy
pip install pymysql.

itā€™s huge data file, so i donā€™t know how to put here. Please let me know if you need more info.

4

I donā€™t need the data. I just need you to read the error message and connect it to the docs for SQLAlchemy.

When you call create_engine, you gave it connect_args={'options': ...}. Looking at the docs, it says

Looking at the docs for pymysql.connections.Connection, we can look at the signature, and itā€™s clear that thereā€™s no keyword named ā€œoptionsā€ there. There also isnā€™t anything named search_path, so Iā€™m not sure what youā€™re attempting there. Perhaps one of the available options is what you want. Perhaps you donā€™t need that option at all. Why are you including it?

1 Like