SELECT INTO GCS syntax error WITH COMPRESSION

SELECT ..
FROM ..
WHERE ..
INTO GCS 'gs://whatever'
CREDENTIALS '{...}'
WITH COMPRESSION

I am getting consistent syntax errors complaining about the WITH COMPRESSION line. If I take the WITH COMPRESSION off it works. I tried moving the statement around the query to see if it was some kind of parser issue but no avail.

Is compression really supported with GCS? What am I doing wrong? This is on a managed service v7.5.12.

looks like SELECT ... INTO GCS ... WITH COMPRESSION wasn’t added until v7.6

1 Like

Looks like it. Thank you!

1 Like