cube-js/cube

RedshiftDriver support UNLOAD (exportBucket) in readOnly mode

开放

#3,032 创建于 2021年6月30日

 (2 条评论) (1 个反应) (0 位负责人)Rust (1,965 个派生)batch import
driver:redshifthelp wanted

仓库指标

星标
 (19,563 个星标)
PR 合并指标
 (PR 指标待抓取)

描述

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

贡献者指南