Sony World Wide Studios: Games, Music, Movies, TV, and More!
dubstep.exe Solving Crack or unlock password for Dubstep.exe and many other programs. DSR18 NUTICK CAMMANCITO BICYCLE TAKEWAY BACKUP.exe. CPanel by cPanelInc. Leam la meaza.Q:
UnicodeEncodeError on reading CSV files from BigQuery
Here is my code:
query = """
SELECT _TABLE_SUFFIX AS PRJNAME,
date,
value
FROM `exp-query-logs.query_logs_test`
WHERE query_id = 100
AND date >= DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 24 HOUR)
"""
# Execute query
query_response = bigquery.Query(
query,
projectId=PROJECT_ID,
config={"timeoutMs": 60000}
).execute()
# Get results
results = query_response.result()
# Open result as a CSV file
dataset = bigquery.Dataset(PROJECT_ID)
job = dataset.open(query_response.jobReference)
query_log_rows = job.query_result()
# Export results to CSV file
query_log_rows.to_csv(file_path=out_file,
file_format="table",
charset="ISO-8859-1",
mode="w",
header=True,
quoting=csv.QUOTE_NON_NUMERIC)
The file has been exported successfully, but the header name of the file contains non-english characters.
Here is a snippet of the
Related links:
Comments