Crea un set di dati e concedi l'accesso
Mantieni tutto organizzato con le raccolte
Salva e classifica i contenuti in base alle tue preferenze.
L'esempio seguente crea un set di dati denominato mydataset, quindi utilizza la risorsa google_bigquery_dataset_iam_policy per concedere l'accesso.
Per saperne di più
Per la documentazione dettagliata che include questo esempio di codice, vedi quanto segue:
Esempio di codice
Salvo quando diversamente specificato, i contenuti di questa pagina sono concessi in base alla licenza Creative Commons Attribution 4.0, mentre gli esempi di codice sono concessi in base alla licenza Apache 2.0. Per ulteriori dettagli, consulta le norme del sito di Google Developers. Java è un marchio registrato di Oracle e/o delle sue consociate.
[[["Facile da capire","easyToUnderstand","thumb-up"],["Il problema è stato risolto","solvedMyProblem","thumb-up"],["Altra","otherUp","thumb-up"]],[["Difficile da capire","hardToUnderstand","thumb-down"],["Informazioni o codice di esempio errati","incorrectInformationOrSampleCode","thumb-down"],["Mancano le informazioni o gli esempi di cui ho bisogno","missingTheInformationSamplesINeed","thumb-down"],["Problema di traduzione","translationIssue","thumb-down"],["Altra","otherDown","thumb-down"]],[],[[["\u003cp\u003eThis code example demonstrates how to create a BigQuery dataset named "mydataset" using Terraform.\u003c/p\u003e\n"],["\u003cp\u003eThe dataset is configured with specific settings, such as a 30-day default partition expiration, a 365-day default table expiration, a description, a location (US), and a 4 day time travel window.\u003c/p\u003e\n"],["\u003cp\u003eIAM policies are defined to grant roles like \u003ccode\u003eroles/bigquery.dataOwner\u003c/code\u003e, \u003ccode\u003eroles/bigquery.admin\u003c/code\u003e, \u003ccode\u003eroles/bigquery.user\u003c/code\u003e, and \u003ccode\u003eroles/bigquery.dataViewer\u003c/code\u003e to different users, groups, and service accounts.\u003c/p\u003e\n"],["\u003cp\u003eThe \u003ccode\u003egoogle_bigquery_dataset_iam_policy\u003c/code\u003e resource applies the defined IAM policies to the created dataset, controlling access and permissions.\u003c/p\u003e\n"]]],[],null,["# Create a dataset and grant access to it\n\nThe following example creates a dataset named mydataset, then uses the google_bigquery_dataset_iam_policy resource to grant access to it.\n\nExplore further\n---------------\n\n\nFor detailed documentation that includes this code sample, see the following:\n\n- [Create datasets](/bigquery/docs/datasets)\n\nCode sample\n-----------\n\n### Terraform\n\n\nTo learn how to apply or remove a Terraform configuration, see\n[Basic Terraform commands](/docs/terraform/basic-commands).\n\n\nFor more information, see the\n[Terraform provider reference documentation](https://registry.terraform.io/providers/hashicorp/google/latest/docs).\n\n resource \"google_bigquery_dataset\" \"default\" {\n dataset_id = \"mydataset\"\n default_partition_expiration_ms = 2592000000 # 30 days\n default_table_expiration_ms = 31536000000 # 365 days\n description = \"dataset description\"\n location = \"US\"\n max_time_travel_hours = 96 # 4 days\n\n labels = {\n billing_group = \"accounting\",\n pii = \"sensitive\"\n }\n }\n\n # Update the user, group, or service account\n # provided by the members argument with the\n # appropriate principals for your organization.\n data \"google_iam_policy\" \"default\" {\n binding {\n role = \"roles/bigquery.dataOwner\"\n members = [\n \"user:raha@altostrat.com\",\n ]\n }\n binding {\n role = \"roles/bigquery.admin\"\n members = [\n \"user:raha@altostrat.com\",\n ]\n }\n binding {\n role = \"roles/bigquery.user\"\n members = [\n \"group:analysts@altostrat.com\",\n ]\n }\n binding {\n role = \"roles/bigquery.dataViewer\"\n members = [\n \"serviceAccount:bqcx-1234567891011-abcd@gcp-sa-bigquery-condel.iam.gserviceaccount.com\",\n ]\n }\n }\n\n resource \"google_bigquery_dataset_iam_policy\" \"default\" {\n dataset_id = google_bigquery_dataset.default.dataset_id\n policy_data = data.google_iam_policy.default.policy_data\n }\n\nWhat's next\n-----------\n\n\nTo search and filter code samples for other Google Cloud products, see the\n[Google Cloud sample browser](/docs/samples?product=bigquery)."]]