Mengkueri set data BigQuery dan menulis hasilnya ke Sheet spreadsheet menggunakan konektor
Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
Mengkueri set data BigQuery menggunakan konektor BigQuery API dan menulis hasilnya ke spreadsheet Google Spreadsheet menggunakan konektor Google Spreadsheet API.
Mempelajari lebih lanjut
Untuk dokumentasi mendetail yang menyertakan contoh kode ini, lihat artikel berikut:
Contoh kode
Kecuali dinyatakan lain, konten di halaman ini dilisensikan berdasarkan Lisensi Creative Commons Attribution 4.0, sedangkan contoh kode dilisensikan berdasarkan Lisensi Apache 2.0. Untuk mengetahui informasi selengkapnya, lihat Kebijakan Situs Google Developers. Java adalah merek dagang terdaftar dari Oracle dan/atau afiliasinya.
[[["Mudah dipahami","easyToUnderstand","thumb-up"],["Memecahkan masalah saya","solvedMyProblem","thumb-up"],["Lainnya","otherUp","thumb-up"]],[["Sulit dipahami","hardToUnderstand","thumb-down"],["Informasi atau kode contoh salah","incorrectInformationOrSampleCode","thumb-down"],["Informasi/contoh yang saya butuhkan tidak ada","missingTheInformationSamplesINeed","thumb-down"],["Masalah terjemahan","translationIssue","thumb-down"],["Lainnya","otherDown","thumb-down"]],[],[],[],null,["# Query a BigQuery dataset and write the results to a Sheet spreadsheet using connectors\n\nQueries a BigQuery dataset using the BigQuery API connector and writes the results to a Sheets spreadsheet using the Google Sheets API connector.\n\nExplore further\n---------------\n\n\nFor detailed documentation that includes this code sample, see the following:\n\n- [Write to Google Sheets from a workflow](/workflows/docs/write-to-google-sheets)\n\nCode sample\n-----------\n\n### YAML\n\n main:\n steps:\n - init:\n assign:\n # Replace with your sheetId and make sure the service account\n # for the workflow has write permissions to the sheet\n - sheetId: \"1D8n7uoU8kGwQvR4rcLkF10CdAfnUKE2o0yl6P-Z7nfM\"\n - limit: 100\n - runQuery:\n call: googleapis.bigquery.v2.jobs.query\n args:\n projectId: ${sys.get_env(\"GOOGLE_CLOUD_PROJECT_ID\")}\n body:\n useLegacySql: false\n # Query name and gender of most popular names\n query: ${\"SELECT name, gender, SUM(number) AS total\n FROM `bigquery-public-data.usa_names.usa_1910_2013`\n GROUP BY name, gender\n ORDER BY total DESC\n LIMIT \" + limit}\n result: queryResult\n - init_header_row:\n assign:\n - rows:\n - [\"Name\", \"Gender\", \"Total\"]\n - process_query_result:\n for:\n value: row\n in: ${queryResult.rows}\n steps:\n - process_each_row:\n assign:\n - name: ${row.f[0].v}\n - gender: ${row.f[1].v}\n - total: ${row.f[2].v}\n - row: [\"${name}\", \"${gender}\", \"${total}\"]\n - rows: ${list.concat(rows, row)}\n - clear_existing_values:\n call: googleapis.sheets.v4.spreadsheets.values.clear\n args:\n range: \"Sheet1\"\n spreadsheetId: ${sheetId}\n result: clearResult\n - update_sheet:\n call: googleapis.sheets.v4.spreadsheets.values.update\n args:\n range: ${\"Sheet1!A1:C\" + (limit + 1)}\n spreadsheetId: ${sheetId}\n valueInputOption: RAW\n body:\n majorDimension: \"ROWS\"\n values: ${rows}\n result: updateResult\n - returnResult:\n return: ${updateResult}\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=workflows)."]]