Choenden Kyirong04/09/2023, 6:01 PM
has all the rows. This seems to take an extremely long time- a bit of a newbie here and i’m wondering if there are any approaches or advice for doing something like this? Thanks!
redsquare04/09/2023, 8:04 PM
Choenden Kyirong04/09/2023, 8:33 PM
, do we have access to those functions?
I’m trying to do this in order to access those functions from
db_block=SqlAlchemyConnector.load("<name>") conn = db_block.get_client(client_type="connection") cursor = conn.cursor()
However, i’m getting the following error:
AttributeError: '_trans_ctx' object has no attribute 'cursor'
redsquare04/09/2023, 8:38 PM
Choenden Kyirong04/09/2023, 8:44 PM
redsquare04/09/2023, 8:46 PM
Choenden Kyirong04/09/2023, 8:47 PM
there may be a slicker way to do it- will look into that. but for now, testing this works.
database_block = SqlAlchemyConnector.load("<name>") with database_block.get_client(client_type="connection") as conn: engine = database_block.get_client(client_type="engine") connection = engine.raw_connection() cursor = connection.cursor() logger = get_run_logger() cursor.copy_from(<filename>)