Can you specify column descriptions for a view in a DDL statement in BigQuery?

Viewed 1665

I know this is possible with a CREATE TABLE statement but I don't see a way to do it with views. I know views support descriptions on columns since I can edit them in the web GUI. I'd like to avoid deploying views with a separate "annotation" file if possible.

I'd like to do something like the following

CREATE VIEW Sandbox.vtest
as
SELECT 1 AS TestField [WITH] OPTIONS(description="An INTEGER field")

This would also work especially now that scripting is possible

ALTER VIEW Sandbox.vtest 
ALTER COLUMN TestField 
SET OPTIONS(description="An INTEGER field")

If it's not possible I'm hoping someone from Google could comment on any future plan to add this functionality. That could at least guide my CI/CD development.

1 Answers
Related