Has Anyone Successfully Managed to Run It?

Bugs
21

thank you for you help :slightly_smiling_face: but I am pretty sure there is something blocking the connection on Pipedream side. You can see that it works in colab without setting home directory and it works in any other Python linux based env

22

have you tried specifying a file in the COPY command like this one?

COPY .....
FROM .....
WITH .....
TO '/tmp/query.csv';

image.png
image.png1340×210 21.6 KB

23

Hello thank you for you response. I am doing the opposite, copying csv data to a table in MotherDuck. The request works fine in python or MotherDuck plateform

24

Capture d’écran 2024-06-14 à 16.07.48.png
Capture d’écran 2024-06-14 à 16.07.48.png1642×1344 252 KB

25

even with very simple request I have the same error

26

Can you try commenting out the COPY command and add the SET command:

con.execute(f"SET home_directory='{home_directory}'")
27

Capture d’écran 2024-06-14 à 16.11.57.png
Capture d’écran 2024-06-14 à 16.11.57.png1746×1456 272 KB

28

the same

29

very strange :disappointed:

30

Looks like the error is occurring at line 9, when creating the connection

31

I’ll search for this and then get back here

32

thank you very much !! I take the exact same code and run it in google colab or locally and it works just fine. Thanks !!

33

hello , the solution is adding:

os.environ[‘HOME’]=‘/tmp’

34

thank you for your help

35

Glad to hear you got the solution!