This statement is run:
SELECT { 'key' : { 'subkey': 'value' }} mycolumn;
What notations will retrieve the 'value' from the VARIANT column? (Choose two.)
This statement is run:
SELECT { 'key' : { 'subkey': 'value' }} mycolumn;
What notations will retrieve the 'value' from the VARIANT column? (Choose two.)
I have checked, as well, in snowflake, all C,D,E are working. For me, D was a surprise. I shall select C and E
I think C D
Unfortunately C,D,E will work in Snowflake: At the same time accorting to documentation Snowflake separates Dot and Bracket Notation, thst's why voting for C and E. https://docs.snowflake.com/en/user-guide/querying-semistructured#traversing-semi-structured-data
select a.mycolumn:key.subkey, a.mycolumn['key'].subkey, a.mycolumn:key:subkey from ( SELECT { 'key' : { 'subkey': 'value' }} mycolumn ) a;