SQLAlchemy data integration tutorials
Tutorials for querying MongoDB, Athena, DynamoDB, BigQuery, Snowflake and other sources from Python with SQLAlchemy and CData Python connectors.
What this integration does
SQLAlchemy is a Python toolkit for working with SQL databases. You create an engine from a connection string, then run queries or use the ORM from scripts and applications. Because the engine hides the database behind one interface, the same code can work with very different back ends.
How CData fits in
CData Python connectors let SQLAlchemy reach sources that are not relational databases. You can query, insert, update and delete live data from a script, and the connector pushes supported operations to the source while its embedded SQL engine handles the rest. The tutorials cover connection strings for each source, the query behavior that affects cost and speed, and the errors people run into most often.
SQLAlchemy tutorials by data source
Amazon AthenaQuerying Athena from SQLAlchemy Without Surprising Your AWS Bill
Set up SQLAlchemy for Athena with the CData Python Connector, pick AWS credentials, manage the S3 staging folder and keep each ORM query narrow.
Amazon DynamoDBSlow DynamoDB Queries in SQLAlchemy: Measure, Trim, Re-measure
Find where time goes when SQLAlchemy reads DynamoDB through the CData Python Connector, then cut it with filters, narrower selects and fewer round trips.
BigQuerySQLAlchemy Can't Reach BigQuery? Check These Things in Order
Work through the usual reasons SQLAlchemy fails against BigQuery with the CData Python Connector: OAuth, project and dataset, URL encoding and mapped classes.
MongoDBUsing SQLAlchemy with MongoDB: Your Questions Answered
Answers to common questions about using SQLAlchemy with MongoDB and the CData Python Connector: connection string, primary keys, filters, DocumentDB and writes.
SnowflakeSQLAlchemy and Snowflake Cheat Sheet: Properties, Queries, Fixes
One-page reference for SQLAlchemy with the CData Python Connector for Snowflake: install, connection properties, engine URL, ORM snippets and common errors.
Don't see your data source or tool?
CData connects hundreds of sources to the tools you already use. Browse the connectors, or talk to us about a specific setup.