v1 Create a BigQuery subscription (DEPRECATED)

  import 
  
 ( 
  
 "context" 
  
 "fmt" 
  
 "io" 
  
 "cloud.google.com/go/pubsub" 
 ) 
 // createBigQuerySubscription creates a Pub/Sub subscription that exports messages to BigQuery. 
 func 
  
 createBigQuerySubscription 
 ( 
 w 
  
 io 
 . 
 Writer 
 , 
  
 projectID 
 , 
  
 subID 
  
 string 
 , 
  
 topic 
  
 * 
 pubsub 
 . 
 Topic 
 , 
  
 table 
  
 string 
 ) 
  
 error 
  
 { 
  
 // projectID := "my-project-id" 
  
 // subID := "my-sub" 
  
 // topic of type https://godoc.org/cloud.google.com/go/pubsub#Topic 
  
 // table := "my-project-id.dataset_id.table_id" 
  
 ctx 
  
 := 
  
 context 
 . 
 Background 
 () 
  
 client 
 , 
  
 err 
  
 := 
  
 pubsub 
 . 
  NewClient 
 
 ( 
 ctx 
 , 
  
 projectID 
 ) 
  
 if 
  
 err 
  
 != 
  
 nil 
  
 { 
  
 return 
  
 fmt 
 . 
 Errorf 
 ( 
 "pubsub.NewClient: %w" 
 , 
  
 err 
 ) 
  
 } 
  
 defer 
  
 client 
 . 
 Close 
 () 
  
 sub 
 , 
  
 err 
  
 := 
  
 client 
 . 
 CreateSubscription 
 ( 
 ctx 
 , 
  
 subID 
 , 
  
 pubsub 
 . 
 SubscriptionConfig 
 { 
  
 Topic 
 : 
  
 topic 
 , 
  
 BigQueryConfig 
 : 
  
 pubsub 
 . 
 BigQueryConfig 
 { 
  
 Table 
 : 
  
 table 
 , 
  
 WriteMetadata 
 : 
  
 true 
 , 
  
 }, 
  
 }) 
  
 if 
  
 err 
  
 != 
  
 nil 
  
 { 
  
 return 
  
 fmt 
 . 
 Errorf 
 ( 
 "client.CreateSubscription: %w" 
 , 
  
 err 
 ) 
  
 } 
  
 fmt 
 . 
 Fprintf 
 ( 
 w 
 , 
  
 "Created BigQuery subscription: %v\n" 
 , 
  
 sub 
 ) 
  
 return 
  
 nil 
 } 
 

  require 
  
 "google/cloud/pubsub" 
 ## 
 # Shows how to create a BigQuery subscription where messages published 
 # to a topic populates a BigQuery table. 
 # 
 # @param project_id [String] 
 # Your Google Cloud project (e.g. "my-project") 
 # @param topic_id [String] 
 # Your topic name (e.g. "my-secret") 
 # @param subscription_id [String] 
 # ID for new subscription to be created (e.g. "my-subscription") 
 # @param bigquery_table_id [String] 
 # ID of bigquery table (e.g "my-project:dataset-id.table-id") 
 # 
 def 
  
 pubsub_old_version_create_bigquery_subscription 
  
 project_id 
 :, 
  
 topic_id 
 :, 
  
 subscription_id 
 :, 
  
 bigquery_table_id 
 : 
  
 pubsub 
  
 = 
  
 Google 
 :: 
 Cloud 
 :: 
  Pubsub 
 
 . 
 new 
  
 project_id 
 : 
  
 project_id 
  
 topic 
  
 = 
  
 pubsub 
 . 
 topic 
  
 topic_id 
  
 subscription 
  
 = 
  
 topic 
 . 
 subscribe 
  
 subscription_id 
 , 
  
 bigquery_config 
 : 
  
 { 
  
 table 
 : 
  
 bigquery_table_id 
 , 
  
 write_metadata 
 : 
  
 true 
  
 } 
  
 puts 
  
 "BigQuery subscription created: 
 #{ 
 subscription_id 
 } 
 ." 
  
 puts 
  
 "Table for subscription is: 
 #{ 
 bigquery_table_id 
 } 
 " 
 end