SORTKEY / DISTKEY When writing data to redshift using AWS Glue

How do I add a sort / dist key to the glue dynamicframe writer into redshift?

主題

分析資料庫

標籤

AWS Glue 提取轉換與載入資料 Amazon Redshift

語言

English

mugiwara

已提問 3 個月前檢視次數 159 次

1 個回答

最新
最多得票
最多評論

這些答案是否有幫助？支持正確答案，以幫助社區從您的知識中受益。

That is part of the table DDL, not the writing itself.
You could have the table previously created with the sort/dist keys as needed, or if you need to create the table dynamically, you could add a preaction to create the table as needed or a post action to alter the table to do that tweaking

專家

Gonzalo Herreros

已回答 3 個月前

mugiwara

3 個月前

I've tried using a post-action like this:,

datasink = glueContext.write_dynamic_frame.from_options(
    frame=dyf,
    connection_type="redshift",
    connection_options={
        "redshiftTmpDir": "..",
        "dbtable": "..",
        "connectionName": "..",
        "postactions": "ALTER TABLE <TABLE> ALTER DISTSTYLE KEY DISTKEY <DIST-COLUMN>, ALTER SORTKEY (<SORT-COLUM-A>, <SORT-COLUMN-B>);"
    },
    transformation_ctx="..",
)

but the problem with specifying them for this problem is that everything works fine the first time the table is created. On subsequent runs, the job fails because you cannot specify THE SAME sort / dist key on the table.

So is there a way to suppress or ignore errors from the post-actions?

SORTKEY / DISTKEY When writing data to redshift using AWS Glue

相關內容