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:

**Table 1** Mapping between DataArts Fabric SQL and LakeFormation data objects
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.

Parent topic: Designing Database Objects

Previous topic: Designing Database Objects

Next topic: Creating and Managing Schemas