Cross Account External Table

BananaHotSauce — Fri, 18 Aug 2023 08:37:37 GMT

I created an external table and set the location on other AWS Account (External Location), lets call it Account B. Databricks workspace is deployed in other account. Lets call it Account A.

Here is my Script

CREATE TABLE devtest.governance.dbtable1(

col1 bigint

col2string

)

LOCATION s3://mys3bucket/governance

Im having an issue when i try to access the file usingf Account B, when i checked, the owner of the file is Account A and Account B is not on the ACL.

It seems like the spark config fs.s3a.acl.default BucketOwnerFullControl did not work.

How can i fix this? What should i change? and where should i change things.

All help appreciated.

Re: Cross Account External Table

Atanu — Wed, 13 Sep 2023 15:23:23 GMT

I think you should start checking from our cross account role access.https://docs.databricks.com/en/administration-guide/account-settings-e2/audit-aws-cross-account.html#step-3-configure-cross-account-support-optional
Check if this is well placed.

topic Re: Cross Account External Table in Data Engineering

Cross Account External Table

Re: Cross Account External Table