Jonathan Mathews
05/04/2022, 3:43 PMautocommit
to trueKevin Kho
05/04/2022, 3:47 PMsnowflake.connector
and seeing if there is no error too?Jonathan Mathews
05/04/2022, 3:50 PMKevin Kho
05/04/2022, 3:52 PMJonathan Mathews
05/04/2022, 4:03 PMAndrew Huang
05/04/2022, 4:04 PMJonathan Mathews
05/04/2022, 4:07 PM"copy into raw.azure.all_tables_all_clients from (select $1::variant as value, cast(split_part(split_part(metadata$filename, '/', -1), '__', 1) as varchar(100)) as client_name, cast(split_part(split_part(metadata$filename, '/', -1), '__', 2) as varchar(100)) as table_name, cast(ltrim(split_part(split_part(metadata$filename, '/', -1), '__', -1), '.parquet' ) as datetime) as export_time, cast(split_part(metadata$filename, '/', -1) as varchar(200)) as filename, cast(metadata$filename as varchar(500)) as filepath from @reporting_raw/test/test.parquet )"
Andrew Huang
05/04/2022, 4:09 PMexecuted = cursor.execute(query, params=data).fetchall()
Jonathan Mathews
05/04/2022, 4:46 PMKevin Kho
05/04/2022, 5:04 PM