Error when Inserting records into Iceberg tables managed by Lake Formation

0

Hello, I was able to create and register a new Iceberg table in my data catalog and Lake Formation using a Glue Job. I used these methods from the documentation:

# Create (equivalent to CREATE TABLE AS SELECT)
dataFrame.writeTo("glue_catalog.databaseName.tableName") \
    .tableProperty("format-version", "2") \
    .create()

# Append (equivalent to INSERT INTO)
dataFrame.writeTo("glue_catalog.databaseName.tableName") \
    .tableProperty("format-version", "2") \
    .append()

I used the first command to create the table and the job succeeded. I attempted to use the second command to insert additional records into the table and received this error:

 An error occurred while calling o14177.pyWriteDataFrame.\n: java.lang.RuntimeException: Failed to get vending credential from Lakeformation. please check if you have sufficient permissions on the table.

How could my glue role have access to create and register a table but not write to it? I confirmed my glue role has SUPER permission on the database and all tables in it, including this one. I've also been able to insert new records into Hudi tables that are in the catalog using the same role. I can't find this error anywhere, what am I missing?

tjtoll
질문됨 5달 전239회 조회
1개 답변
0
수락된 답변

Hi,

Usually this error occurs if the Job is unable to connect to Lakeformation service.

Would you be able to share the full error trace from the logs of your failed Glue job ? I would also recommend you to raise a support case for much closer inspection.

AWS
지원 엔지니어
답변함 4달 전
profile picture
전문가
검토됨 한 달 전
  • Thanks - I'll raise a case

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠