After unlocking the code and saving it, the columns in the output table are removed
from metadata. This is because the data builder uses the columns selected on the
Design tab to create
column metadata, and those column selections are no longer available after you unlock the view on
the
Code tab.
When you run the unlocked data query, the column metadata is registered as part of
running the code. However, the columns might not be visible
in the data builder immediately because the
table metadata (without any columns) is
cached in the
application.
If you did not save
the query at least one time before unlocking the code, you will receive
empty columns when you run the query. Make sure that you save the
query before you unlock the code.