I am trying to create a dask dataframe from a table in postgres. I would like to pass the application_name = 'myapp' as a standard for monitoring and tracking DB activity.
But when am trying to add the parameter, I getting below error.
ddf = dd.read_sql_table('table',
uri,
schema='schema',
index_col='index_col',
engine_kwargs={'application_name':'myapp'})
TypeError: Invalid argument(s) 'application_name' sent to create_engine(), using configuration PGDialect_psycopg2/QueuePool/Engine. Please check that the keyword arguments are appropriate for this combination of components.
application_namea valid input, where do you expect this to go? - mdurantcreate_engine()does not want this keyword. Can you create a sqalchemy engine independently? - mdurant