SnowPro Specialty Gen AI GES-C01

By Snowflake · Question Mode

QuestionQ60

VerifiedSnowflake Gen AI & LLM Functions

A Gen AI Specialist is creating metadata for Snowflake Cortex Analyst by creating a semantic model. The relationship between the PRODUCTS and PRODUCT_SALES tables is defined as:

Question Image

Which join will Cortex Analyst generate in a query that uses this model?

Explanation

A left_outer relationship uses the declared left table as the preserved table. With PRODUCT_SALES as the left table, PRODUCTS as the right table, and the column mapping from PRODUCT_SALES.PRODUCT_ID to PRODUCTS.ID, the generated SQL is a left outer join from PRODUCT_SALES to PRODUCTS using S.PRODUCT_ID = P.ID. Snowflake documents that semantic-model relationships define how Cortex Analyst joins logical tables.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!