Status Update
Comments
bl...@google.com <bl...@google.com>
ad...@google.com <ad...@google.com> #2
ug...@google.com <ug...@google.com> #4
Hi Octavio, this item is currently in the backlog. We will update when it moves up to execution, I cannot share any timelines as of yet.
li...@covergenius.com <li...@covergenius.com> #5
Any update on this? It is quite convenient to have this feature.
fr...@google.com <fr...@google.com> #6
While this implementation is not available, there are other methods available for creating tables with policy tags added to the columns:
-
Using the Cloud Console and editing the schema as text to include the policy tags, as shown in [1].
-
Using the
bq mk
command and specifying the policy tags in the schema JSON. To achieve this you could follow [2] -
Using one of the available client libraries and creating an empty table specifying a schema with the policy tags. In Python this could be achieved by specifying the
policy_tags
parameter in theSchemaField
. An example of a schema that specifies a policy tag in a column in [3]. More infromationn on creating a table with schema definition using client libraries (Python, Java, Node.js,...) can be found in [3].
[1] Set a policy tag on a column (Console):
[2] Set a policy tag on a column (bq mk command):
[3]
schema = [
bigquery.SchemaField("full_name", "STRING", mode="REQUIRED"),
bigquery.SchemaField("age", "INTEGER", mode="REQUIRED", policy_tags=bigquery.PolicyTagList(names=["projects/<project-id>/locations/<location>/taxonomies/<taxonomy-id>/policyTags/<policytag-id>
"])),
]
[4] Create an empty table with a schema definition:
fm...@fmlogistic.com <fm...@fmlogistic.com> #7
BR
ma...@mpb.com <ma...@mpb.com> #8
nr...@google.com <nr...@google.com>
nr...@google.com <nr...@google.com>
pl...@google.com <pl...@google.com> #9
Hello, I am the owner of a support case and I want to know if there is an ETA to get this feature implemented.
Thank you in advance!
nr...@google.com <nr...@google.com>
nr...@google.com <nr...@google.com>
nr...@google.com <nr...@google.com>
ri...@google.com <ri...@google.com> #10
fe...@google.com <fe...@google.com> #11
do...@swarovski.com <do...@swarovski.com> #12
Also raise this, to highlight Dataform connection.
Description
Problem you have encountered:
It is not possible to add a policy tags in a create table or create as query_statement DDL statement.
What you expected to happen:
To be able to run DDL as the following:
CREATE TABLE mydataset.newtable
(
x INT64 OPTIONS(description="An optional INTEGER field"),
y STRING OPTIONS(description="An optional INTEGER field", policy_tag="projects/myproject/locations/eu/taxonomies/000/policyTags/000")
)