cube-js/cube

RedshiftDriver support UNLOAD (exportBucket) in readOnly mode

Open

#3,032 建立於 2021年6月30日

在 GitHub 查看
 (2 留言) (1 反應) (0 負責人)Rust (1,965 fork)batch import
driver:redshifthelp wanted

倉庫指標

Star
 (19,563 star)
PR 合併指標
 (平均合併 5天 16小時) (30 天內合併 138 個 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

貢獻者指南