I could not find examples of solutions to this simple query in SQLAlchemy. Can SQLAlchemy replace T-SQL ETL data modify or not?
select a.field1, a.field2, b.field2
from database1.schema1.table_a as a
inner join database2.schema1.table_b as b
on a.fileld1 = b.fileld1
I use this connection with windows authentication:
engine = create_engine(
"mssql+pyodbc://@{Server}/{database}?driver=SQL+Server?trusted_connection=yes"
)
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…