Can't pass both a connection string and config options to connect method in sqlalchemycontext

[elsander]

In theory, the options argument in the connect method is meant to allow you to pass arguments to the connection method for either the pandas or sql context. However, for the sqlalchemy context, the first argument to create_engine is an unnamed argument containing the database URL. I can't find a way to pass both a db connection string and a dict of config options, which means that I can't use the class connect to databases where I require non-default options. My current workaround is to create my own engine and pass it in to SqlAlchemyDataset.

The current data context test demonstrates this behavior by passing a connection string rather than config options to the connect method:

great_expectations/tests/test_data_contexts/test_data_contexts.py

Line 40 in d7a4ee0

context = get_data_context('SqlAlchemy', test_db_connection_string)