CSV file to Bigquery

Bhanu chander Shyamala

Data Analyst

Bigquery Intro:

Bigquery is a fully managed, serverless data warehouse that enables scalabale analysis over petabytes of data and it also has built-in machine learning capabilities. Bigquery was announced in the may 2010 and generally availble in november 2011

How to upload CSV file into Bigquery?

Create-Table option from Bigquery interface

Lets follow the below steps to complete the uploading of CSV file to bigquery

  • Select the bigquery option from google cloud console as shown in the below
  • Bigquery interface
  • Click on create table option in the bigquery interface
  • Select the upload option
  • Browse and Upload the CSV file
  • Write the table name in the input box
  • Skip the header 1 because it is already mentioned in the CSV file
  • Last step, Just click on the create table option in seconds your table will be created

    • Comments

    Post a Comment

    Popular posts from this blog

    Overview of data storage and sql commands

    Image
    Data acquired from various sources Bhanuchander Shyamala Data Analyst Before Databases , data had to be recorded on paper. we had millions of records like that and stored in the racks. when it was necessary to access one of these records finding the files and searching for specific information is the laborious task. There were problems ranging from misplaced records to fires that wiped out entire archives and destroyed the history of societies, Organizations and government. File Based: In the late 1960's file based database were introduced. In the file based databases, data was maintained in the flat file. Hierarchical data model: It was IBM's first DBMS and called the information management system. Network model: It was first DBMS model at Honeywell called Integrated Data Store. Relational Database: It is the era of relational database and database management. In 1970's, the relational model was proposed by E.F Codd. Cloud Database: Cloud datastore...
    Read more