cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

Cross Account External Table

BananaHotSauce
New Contributor III

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.

1 REPLY 1

Atanu
Databricks Employee
Databricks Employee

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... 
Check if this is well placed.

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group