cube-js / cube-js/cube

RedshiftDriver support UNLOAD (exportBucket) in readOnly mode

Open
#3,032 2 comments 1 reaction 0 assignees View on GitHub
driver:redshift help wanted
Dominant language
Rust
Stars
20.8k
Forks
2.1k
Avg merge
1d 2h
Merged PRs (30d)
181

Description

Hello!

We started to support UNLOAD (exportBucket) in Redshift driver, but it's still limited and there are no support for readOnly mode.

Why?

Because We need column types for CSV, without it it's not possible to create a table in an external storage. In readOnly mode we dont create table before extraction and use original SQL, but there is no good way to do it.

Solution:

1. SELECT query with LIMIT 0 to extract types.
2. CREATE TEMP table and describe it via INFORMATION_SCHEMA.

Thanks

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.