Understanding DataArts Fabric SQL Database Objects
DataArts Fabric SQL is a cloud-native database engine that leverages the capabilities of DataArts LakeFormation (LakeFormation, a unified metadata management engine for data lakes) and Object Storage Service (OBS) for efficient data management.
In DataArts Fabric SQL, the creation, management, and deletion of data objects are associated with LakeFormation. LakeFormation provides persistent metadata storage for data in OBS. You can use DataArts Fabric SQL to quickly and conveniently operate LakeFormation metadata.
To learn more about LakeFormation, refer to LakeFormation.
There is a specific mapping relationship between database objects in DataArts Fabric SQL and LakeFormation data objects, as shown below:
DataArts Fabric SQL Database Object |
LakeFormation Database Object |
Description |
---|---|---|
Database |
Catalog |
In DataArts Fabric SQL, when a user logs in to a database, they are automatically connected to the catalog specified by LakeFormation. Users cannot access metadata across catalogs. |
Schema |
Database |
The schema in DataArts Fabric SQL corresponds to the database in LakeFormation. |
Table |
Table |
The table-level mapping in DataArts Fabric SQL aligns with that of LakeFormation. |
IAM user |
IAM user |
DataArts Fabric SQL currently only supports access from IAM users. |

- Database objects in DataArts Fabric SQL cannot be created, modified, or deleted. When a user logs in to DataArts Fabric SQL, they are automatically connected to the catalog specified by LakeFormation. Users can efficiently and swiftly use LakeFormation metadata and OBS data using SQL syntax.
- DataArts Fabric SQL currently only supports access from IAM users.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot