From d064b2ec2c7393f8de50560a7edfe100851bfea3 Mon Sep 17 00:00:00 2001 From: T-Aji Date: Wed, 28 Aug 2024 14:39:13 +0100 Subject: debugging load_lambda --- src/load_lambda.py | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'src') diff --git a/src/load_lambda.py b/src/load_lambda.py index 926b4db..272cb8c 100644 --- a/src/load_lambda.py +++ b/src/load_lambda.py @@ -164,13 +164,13 @@ def upload_dfs_to_database(): "dim_date.parquet", # this needs to be mutable "dim_location.parquet", "dim_staff.parquet", - "dim_design.parquet", + "dim_design.parquet" ] mutable_df_dict = [ "fact_sales_order", "fact_purchase_order", "fact_payment", - "dim_currency", + "dim_currency" ] for file_name, df in dict_of_dfs.items(): @@ -182,6 +182,7 @@ def upload_dfs_to_database(): df.to_sql( table_name, con=db_engine, + schema="project_team_2", if_exists="append", index=False, ) -- cgit v1.2.3