[jira] [Commented] (AIRFLOW-3163) Add set table description operator to BigQuery operators

["jack (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/AIRFLOW-3163?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16817922#comment-16817922 ] 

jack commented on AIRFLOW-3163:
-------------------------------

This no longer needed.

Google introduced ALTER TABLE:

 
{code:java}
#standardSQL
ALTER TABLE IF EXISTS mydataset.newtable SET OPTIONS(description="a table that expires in 2020")
 
{code}
[https://cloud.google.com/bigquery/docs/reference/standard-sql/data-definition-language#alter_table_set_options_statement]

 

The feature is still in beta but seems like there is no need for this request any more as you can just run SQL query with BigQueryOperator on your table.

> Add set table description operator to BigQuery operators
> --------------------------------------------------------
>
>                 Key: AIRFLOW-3163
>                 URL: https://issues.apache.org/jira/browse/AIRFLOW-3163
>             Project: Apache Airflow
>          Issue Type: Improvement
>          Components: operators
>    Affects Versions: 1.10.0
>            Reporter: Anthony Brown
>            Assignee: Anthony Brown
>            Priority: Minor
>
> When populating lots of tables as results from BigQuery sql statements, it would be useful to set a description on the table to include something like last updated date
>  
> This will add an operator to the BigQuery class to include it



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)