
<p>This is a quick note on how to delete unused GCP Projects to save money.</p>
<h2>Go to Cloud Resource manager</h2>
<p>
  Click this link to go to the
  <a href="https://console.cloud.google.com/cloud-resource-manager"
    >cloud resource manager</a
  >
  page, and choose the setting to showdown the projects to avoid billings.
</p>
<h2>Create another GCP account to get $300 credit</h2>
<p>
  If you just want to test the GCP for your project without accidentally paying
  a lot, you can use a new email to register a new GCP account to get $300
  credit in 90 days.
</p>


This is a quick note on how to delete unused GCP Projects to save money.

How to Delete GCP Projects


<p>
  GCP Pub/Sub is managed messaging service provide by GCP, this blog demo how to
  create Pub/Sub and use dataflow to subscribe data into BigQuery.
</p>
<h2>Create BQ Table for test</h2>
<p>
  <span style="font-weight: 400"
    >First, need to create a BQ table, so we can store our message from Pub/Sub
    we send, below is the JSON and BQ Table assume we want to store the
    information.</span
  >
</p>
<p>
  <code
    ><span style="font-weight: 400"
      >{&ldquo;id&rdquo;: 100, &ldquo;name&rdquo;:&rdquo;Smith James",
      url:&rdquo;</span
    ><a href="about:blank"
      ><span style="font-weight: 400"
        >https://testsmithjames.com&rdquo;,&rdquo;age&rdquo;:30,&rdquo;price&rdquo;:300,&rdquo;desc&rdquo;:&rdquo;I
        like sell my arts.</span
      ></a
    ><span style="font-weight: 400">&rdquo;}</span></code
  >
</p>
<h2><span style="font-weight: 400">PubSub Topic</span></h2>
<p>
  <span style="font-weight: 400"
    >Here, we try to create a topic via gcloud command line,&nbsp;</span
  >
</p>
<p class="p1"><span class="s1">To create a PubSub Topic</span></p>
<p class="p1">
  <code
    ><span class="s1">gcloud pubsub topics create test_topic_myname</span></code
  >
</p>
<p class="p1">
  <span class="s1"
    >In case, need to delete the topic, below command is how to delete a PubSub
    Topic</span
  >
</p>
<p class="p1">
  <code
    ><span class="s1">gcloud pubsub topics delete test_topic_myname</span></code
  >
</p>
<h2>Create a Dataflow</h2>
<p>
  Now, the following command example will create a dataflow job by using the
  template PubSub to BigQuery and will insert the new record to the Big Query
  table defined.
</p>
<p>This command also expects the cloud bucket already exists.</p>
<pre
  class="language-bash"
><code>gcloud dataflow jobs run ps-to-bq-test-topic-myname --gcs-location gs://dataflow-templates-us-central1/latest/PubSub_to_BigQuery --region us-central1 --staging-location gs://test-pubsub-name-topic/temp --parameters inputTopic=projects/test-dataflow-sql/topics/test_topic_myname,outputTableSpec=test-dataflow-sql:dataflow_sql_tutorial.test_pubsub_to_bq</code></pre>
<h2 class="p1"><span class="s1">Manually Publish PubSub Message</span></h2>
<p>
  <span class="s1"
    >Let's test the PubSub Dataflow to BigQuery, go to the GCP Pub/Sub page, and
    paste the below Json, once click the publish button should see the new
    record in BigQuery table.</span
  ><span class="s1"></span>
</p>
<pre class="language-markup"><code>{
  "id": 100,
  "name": "smith james",
  "url": "https://testsmithjames.com",
  "age": 30,
  "price": 300,
  "desc": "I like sell my arts"
}</code></pre>
<h2>Send Pub/Sub Message from C#</h2>
<p>
  Following is a sample code by using C# to send a message to the projecId and
  topicId.
</p>
<pre
  class="language-csharp"
><code>TopicName topicName = TopicName.FromProjectTopic(ProjectId, TopicId);

PublisherClient publisher = await PublisherClient.CreateAsync(topicName);

SamplePubSubModel sampleModel = new()
{
                id = 304,
                name = "my name",
                url = "https://test-url",
                age = 40,
                price = 300,
                desc = "some desc"
};

await publisher.PublishAsync(JsonConvert.SerializeObject(sampleModel));</code></pre>
<p>
  Above C# code require the Google.Cloud.PubSub.V1, but also need to
  authenticate then the code will successfully run.
</p>
<h2>Authenticating as a service account</h2>
<p>
  Now, just run the C# code above, and you'll see the exception which requires
  providing the google credentials. There're a few ways to achieve this, what
  we're doing here is trying to create a service account that has permission to
  pub/sub message.
</p>
<p>
  Once create a service account, make sure has the Role
  <code>Pub/Sub Publisher</code>.
</p>
<p>
  Create a token and save the credential JSON file to the local, if you're using
  windows, run the below command. Now, after following the below command, might
  still see the credential error but, it might be fixed after restarting the
  windows.
</p>
<p><code>set GOOGLE_APPLICATION_CREDENTIALS=key_path</code></p>
<h2>Conclusion</h2>
<p>
  Should be very easy to set up all processes, but might take some time on how
  the google application credentials especially if you're using windows.
</p>
<p></p>


GCP Pub/Sub is managed messaging service provide by GCP, this blog demo how to create Pub/Sub and use dataflow to subscribe datainto BigQuery.

PubSub to BigQuery via Dataflow with GCP


<p>This blog shows a quick memo on how to get started with GCP cloud cli.</p>
<h2>Install GCP SDK</h2>
<p>
  <a
    href="https://cloud.google.com/sdk/docs/install-sdk"
    title="install gcp sdk"
    target="_blank"
    rel="noopener"
    >https://cloud.google.com/sdk/docs/install-sdk</a
  >
</p>
<p>
  Also, reference here for release note
  <a
    href="https://cloud.google.com/sdk/docs/release-notes"
    title="gcp cli release notes"
    target="_blank"
    rel="noopener"
    >https://cloud.google.com/sdk/docs/release-notes</a
  >
</p>
<h2>Install SDK</h2>
<p>
  for Mac OS, double click the .<strong>/install.sh</strong> to install to the
  Mac OS.
</p>
<h2>gcloud init</h2>
<p>
  Run the <code>gcloud init</code> to configure the GCP cloud cli, this will
  start authentication of the Google. If you have multiple different GCP
  accounts, you can also use the <code>gcloud init</code> to switch to a
  different account.
</p>
<h2>Confirm current GCP setting</h2>
<h3>gcloud config list</h3>
<p>
  run <code>gcloud config list</code> to check the current GCP account and
  current GCP project.
</p>
<p>
  run <code>gcloud projects list</code> to view all the projects at the current
  GCP account.
</p>
<p>
  use <code>gcloud config set project {project id}</code> to set the gcp project
  id.
</p>


This blog shows a quick memo on how to get started with GCP cloud cli.

Category GCP

How to Delete GCP Projects

PubSub to BigQuery via Dataflow with GCP

Quick Start to Install Google Cloud Cli