Esegui una query SQL precedente con pandas-gbq
Mantieni tutto organizzato con le raccolte
Salva e classifica i contenuti in base alle tue preferenze.
Utilizza il pacchetto pandas-gbq per eseguire una query utilizzando la sintassi SQL precedente.
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\u003eThe \u003ccode\u003epandas-gbq\u003c/code\u003e package can be used to execute queries against BigQuery.\u003c/p\u003e\n"],["\u003cp\u003eThis example demonstrates running a query with legacy SQL syntax using \u003ccode\u003epandas-gbq\u003c/code\u003e.\u003c/p\u003e\n"],["\u003cp\u003eThe \u003ccode\u003eread_gbq\u003c/code\u003e function is used to execute the SQL query and retrieve the results.\u003c/p\u003e\n"],["\u003cp\u003eTo use legacy SQL syntax, set the \u003ccode\u003edialect\u003c/code\u003e parameter to \u003ccode\u003e"legacy"\u003c/code\u003e in the \u003ccode\u003eread_gbq\u003c/code\u003e function.\u003c/p\u003e\n"],["\u003cp\u003eAuthenticating with Bigquery requires setting up Application Default Credentials.\u003c/p\u003e\n"]]],[],null,["# Run a legacy SQL query with pandas-gbq\n\nUse the pandas-gbq package to run a query using legacy SQL syntax.\n\nCode sample\n-----------\n\n### Python\n\n\nBefore trying this sample, follow the Python setup instructions in the\n[BigQuery quickstart using\nclient libraries](/bigquery/docs/quickstarts/quickstart-client-libraries).\n\n\nFor more information, see the\n[BigQuery Python API\nreference documentation](/python/docs/reference/bigquery/latest).\n\n\nTo authenticate to BigQuery, set up Application Default Credentials.\nFor more information, see\n\n[Set up authentication for client libraries](/bigquery/docs/authentication#client-libs).\n\n sql = \"\"\"\n SELECT country_name, alpha_2_code\n FROM [bigquery-public-data:utility_us.country_code_iso]\n WHERE alpha_2_code LIKE 'Z%'\n \"\"\"\n df = pandas_gbq.read_gbq(\n sql,\n project_id=project_id,\n # Set the dialect to \"legacy\" to use legacy SQL syntax. As of\n # pandas-gbq version 0.10.0, the default dialect is \"standard\".\n dialect=\"legacy\",\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)."]]