-
Notifications
You must be signed in to change notification settings - Fork 17
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Unable to set TABLE() return type #99
Comments
In order to return TABLE(), please use an alternative syntax, which is similar to table columns:
It is documented, but probably not very clear. Hmm.. maybe I should add an explicit warning to output about this. |
Ah, it is about Initially you may try this syntax:
If it does not work, I'll update the code to take this use case into account. |
That seems to work. Though it is not very intuitive. Not sure how it could be expressed better. Maybe just documenting it is enough. |
I'll add test and note in documentation with the next update. Thank you for pointing this out. |
Updated documentation for PROCEDURE object type. |
Describe the bug
When declaring a procedure I would like to be able to set the return type to
TABLE()
since I do not know the return schema before the procedure executes. Currently I get an error.Expected behavior
Compiles appropriately.
See Snowflake docs: https://docs.snowflake.com/en/developer-guide/stored-procedure/stored-procedures-snowflake-scripting
Attach log
ValueError: Could not parse data type string [TABLE()]
Attach YAML config (if applicable)
Any help would be appreciated!
The text was updated successfully, but these errors were encountered: