entity-creation

To define a semantic entity mapped to a data warehouse table, you specify the entity name, business concept, granularity, and unique keys in a YAML configuration. This process maps the entity directly to a physical table source within the Honeydew semantic layer.

Yes, you can create a semantic entity using custom SQL. The entity creation process supports mapping entities to custom SQL queries in addition to physical tables and virtual entities, allowing flexible source data modeling within your YAML definitions.

A virtual entity in semantic modeling is a business concept defined within the Honeydew semantic layer that derives from other entities rather than a direct physical table. It allows you to expose specific attributes while maintaining consistent data modeling granularity.

You expose specific columns as attributes by selecting source columns during the entity creation process. This involves configuring your YAML definitions to specify which data warehouse source columns become accessible attributes for the semantic entity.

Yes, you need precise YAML definitions to configure entities in the Honeydew semantic layer. The YAML format is required to specify entity configurations, dataset mappings, owners, and unique identifiers for proper data warehouse integration.

The best way to map a Customers table to a semantic entity is to define the entity name and keys in YAML, then map it to your physical data warehouse table like ANALYTICS.PUBLIC.CUSTOMERS. You then expose desired columns like customer_id and email as attributes.