cube-js/cube
RedshiftDriver support UNLOAD (exportBucket) in readOnly mode
オープン
#3,032 opened on 2021/06/30
driver:redshifthelp wanted
Repository metrics
- Stars
- (19,563 個のスター)
- PR merge metrics
- (PR metrics pending)
説明
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:
- SELECT query with LIMIT 0 to extract types.
- CREATE TEMP table and describe it via INFORMATION_SCHEMA.
Thanks