---
title: "BigQuery create partitioned table and load CSV with Apps Script"
author: "Sourabh Choraria"
date: 2020-01-03T08:12:18+00:00
modified: 2020-01-03T08:12:20+00:00
canonical_url: https://pulse.appsscript.info/p/2020/01/bigquery-create-partitioned-table-and-load-csv-with-apps-script/
markdown_url: https://pulse.appsscript.info/p/2020/01/bigquery-create-partitioned-table-and-load-csv-with-apps-script.md
categories:
  - "Sheets"
  - "Solutions"
tags:
  - "@st3phcloud"
  - "Medium"
  - "stephane.giron"
description: "Work with partitioned table and upload a csv file in BigQuery with Apps Script. BigQuery is the famous Google database to store huge amount of data and query them fastly. For a recent a project..."
---

# BigQuery create partitioned table and load CSV with Apps Script

[![](https://miro.medium.com/max/640/1*LKYY_gP_y24Bg1NVEwxsDw.png)](https://medium.com/@stephane.giron/bigquery-create-partitioned-table-and-load-csv-with-apps-script-da54dba5d8c)

> Work with partitioned table and upload a csv file in BigQuery with Apps Script.

BigQuery is the famous Google database to store huge amount of data and query them fastly. For a recent a project I had to use it for storing some logs so here the code used with Google Apps Script to create the table and load a csv file from Google Drive.

Source: *[BigQuery create partitioned table and load CSV with Apps Script*](https://medium.com/@stephane.giron/bigquery-create-partitioned-table-and-load-csv-with-apps-script-da54dba5d8c)

---

*Published by [Sourabh Choraria](https://pulse.appsscript.info/p/author/scriptgs/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2020/01/bigquery-create-partitioned-table-and-load-csv-with-apps-script/](https://pulse.appsscript.info/p/2020/01/bigquery-create-partitioned-table-and-load-csv-with-apps-script/)*