Skip to content

Instantly share code, notes, and snippets.

import requests as req
from pdfreader import PDFDocument, SimplePDFViewer
import requests
headers = {
'from': 'ori.keshet@solaredge.com',
file_content = str()
def bluhbluh(file_name_str):
with open(file_name_str, "r") as f:
exported_str = f.read()
return exported_str
grand_total_ctl_files = glob.glob("*.ctl")
with ThreadPoolExecutor(max_workers=100) as e:### כ-100 threads
all_files_data = list(e.map(bluhbluh, grand_total_ctl_files))
for __unit_data in all_files_data:
-- Controller to load data from csv file to CSE_INT_BATCHES_B and TL table.
OPTIONS(ROWS=1)
LOAD DATA
INFILE 'CseAssetBatches.csv'
BADFILE 'CseAssetBatches.bad'
DISCARDFILE 'CseAssetBatches.dsc'
APPEND
INTO TABLE FUSION.CSE_INT_BATCHES_B
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS