BigQueryLoader Constructor(String,BigQueryConnection)

On this page

Initializes a new instance of the BigQueryLoader class with table name that will be loaded and a BigQueryConnection object.

Syntax

Visual Basic
C#


'Declaration Public Function New( _ ByVal tableName As String, _ ByVal connection As BigQueryConnection _ )


public BigQueryLoader( string tableName, BigQueryConnection connection )

Parameters

tableName: Name of the table that will be loaded.
connection: A BigQueryConnection object that represents the connection to a data source.

Remarks

Use this constructor to set TableName and Connection properties at the time of initialization.

Example

The following example creates a BigQueryLoader and sets some of its properties. Then prepares data and loads it into the table.

csharp


public void CreateMyLoader() { // Create and open connection BigQueryConnection conn = new BigQueryConnection( @"Authentication Type=ServiceAccount;ServiceAccount Json=C:\keys\service-account.json;Project Id=your_project;DataSet Id=your_dataset;License Key=**********"); conn.Open(); // Create loader instance BigQueryLoader loader = new BigQueryLoader("loader_test", conn); // Prepare for loading loader.Open(); // Set row values for (int i = 0; i < 10000; i++) { loader.SetValue(0, i); loader.SetValue(1, "test string"); loader.SetValue(2, DateTime.Now); // Load next table row loader.NextRow(); } // Flush buffer and finish loading loader.Close(); }

public void CreateMyLoader()
{
  // Create and open connection
  BigQueryConnection conn = new BigQueryConnection(
      @"Authentication Type=ServiceAccount;ServiceAccount Json=C:\keys\service-account.json;Project Id=your_project;DataSet Id=your_dataset;License Key=**********");
  conn.Open();

  // Create loader instance
  BigQueryLoader loader = new BigQueryLoader("loader_test", conn);
     
  // Prepare for loading
  loader.Open();

  // Set row values
  for (int i = 0; i < 10000; i++) {
    loader.SetValue(0, i);
    loader.SetValue(1, "test string");
    loader.SetValue(2, DateTime.Now);
    // Load next table row
    loader.NextRow();
  }

  // Flush buffer and finish loading
  loader.Close();
}

Visual Basic


Public Sub CreateMyLoader() ' Create and open connection Dim conn As BigQueryConnection = new BigQueryConnection( _ "Authentication Type=ServiceAccount;ServiceAccount Json=C:\keys\service-account.json;Project Id=your_project;DataSet Id=your_dataset;License Key=**********") conn.Open() ' Create loader instance Dim loader As BigQueryLoader = new BigQueryLoader("loader_test", conn) ' Prepare for loading loader.Open() ' Set row values Dim i As Integer For i = 0 To 10000 loader.SetValue(0, i) loader.SetValue(1, "test string") loader.SetValue(2, DateTime.Now) ' Load next table row loader.NextRow() next ' Flush buffer and finish loading loader.Close() End Sub

Public Sub CreateMyLoader()
  ' Create and open connection
  Dim conn As BigQueryConnection = new BigQueryConnection( _
      "Authentication Type=ServiceAccount;ServiceAccount Json=C:\keys\service-account.json;Project Id=your_project;DataSet Id=your_dataset;License Key=**********")
  conn.Open()

  ' Create loader instance
  Dim loader As BigQueryLoader = new BigQueryLoader("loader_test", conn)
     
  ' Prepare for loading
  loader.Open()

  ' Set row values
  Dim i As Integer
  For i = 0 To 10000
    loader.SetValue(0, i)
    loader.SetValue(1, "test string")
    loader.SetValue(2, DateTime.Now)
    ' Load next table row
    loader.NextRow()
  next

  ' Flush buffer and finish loading
  loader.Close()
End Sub

Reference

BigQueryLoader Class
BigQueryLoader Members
Overload List
Devart.Data.BigQuery.BigQueryLoaderColumn
Devart.Data.BigQuery.BigQueryLoaderColumnCollection

Send Feedback