Snowflake variant columns can be accessed using which notations?

• A. Dot notation only
• B. Bracket notation only
• C. Dot notation and bracket notation
• D. Neither

Answer: (C)

Variant data holds JSON-like structures, and you reach nested fields using two notations: dot notation and bracket notation. Dot notation is concise and works when the field names are valid identifiers (no spaces or special characters). Bracket notation is more flexible: you can access keys with spaces or special characters, and you can use numeric indices for arrays. For example, with a variant column v containing {"employee": {"name": "Alice", "skills": ["SQL","Python"]}}, you can write v.employee.name or v['employee']['name']; for arrays, v.employee.skills[0] or v['employee']['skills'][0]. Both forms are supported, so you can use either depending on the context.