SSC-EWI-TD0060
JSON_TABLE not transformed, column names could not be retrieved from semantic information
Last updated
JSON_TABLE not transformed, column names could not be retrieved from semantic information
Last updated
Low
The JSON_TABLE function can be transformed by SnowConvert, however, this transformation requires knowing the name of the columns that are being selected in the JSON_TABLE ON subquery.
This message is generated to warn the user that the column names were not explicitly put in the subquery (for example, a SELECT * was used) and the semantic information of the tables being referenced was not found, meaning the column names could not be extracted.
If you want know how to load JSON data into a table check this
Please check the code provided to SnowConvert is complete, if you did not provide the table definition please re-execute the code with the table definition present.
If you need more support, you can email us at