Details
-
Improvement
-
Resolution: Done
-
Major
-
Goldfish Private Preview
-
0
-
Analytics Sprint 29, Analytics Sprint 30
Description
Example:
COPY (
|
SELECT VALUE c
|
FROM Commerce.Customers c
|
WHERE c.city IN ["Boston, MA", "Hanover, MA"]
|
) AS t
|
TO myS3Bucket AT myS3Link
|
PATH ("commerce", state, zip) -- allow multiple expressions
|
OVER (
|
PARTITION BY t.address.state AS state,
|
t.address.zipcode AS zip
|
)
|
WITH {
|
"compression": "gzip"
|
}
|
|
Path expressions should be concatenated by path separators