Topic: How to read data from Google Sheet Using Big Query. In this article, we will learn how to read data from Google Sheets using BigQuery. BigQuery is a powerful tool that allows you to access, analyze, visualize, and share billions of rows of data from your spreadsheet with Connected Sheets, the new BigQuery data connector. To get started, you need to meet all of the following requirements: Access to the Google Cloud platform, BigQuery access, and a project with billing setup in BigQuery. Once you have met these requirements, you can create a BigQuery table with the da ..read more

Topic: How to upgrade GCP Postgresql from old version to the new version by using Database Migration DMS in GCP. Here’s a step-by-step guide to upgrading GCP PostgreSQL from an old version to a new version by using Database Migration Service (DMS) in GCP: 1.       Create a service account in the Google Cloud Console with the necessary permissions to access your GCP project, PostgreSQL instance, and DMS. You can follow the instructions provided in the official documentation. 2.       Install the Google Cloud SDK on your ..read more

Topic: How to Get the List of all Files with Size, Modified and Path from GCS Bucket and Load into BigQuery. In this post, you will learn how to get the list of all files with their size, modified date, and path from a Google Cloud Storage (GCS) bucket and load them into BigQuery. We will guide you through the process step by step, starting with setting up the necessary permissions and credentials for accessing GCS and BigQuery. By the end of this video, you will clearly understand how to extract file metadata from a GCS bucket, load it into BigQuery, and leverage its powerful querying ..read more

Topic: How to use Bing AI to write SQL Server Queries as SQL Server Developer or SQL Server DBA. Introduction Bing AI is a powerful tool that can help you generate SQL queries quickly and easily. Whether you’re a SQL Server Developer or a SQL Server DBA, Bing AI can help you write complex SQL queries in seconds without knowing SQL. In this blog post, we’ll explore how to use Bing AI to generate SQL queries. Prerequisites Before we begin, make sure you have the following: A Bing account. A basic understanding of SQL. Step-by-Step Guide Sign in to Bing: Sign in to your Bing account. Open B ..read more

Topic: How to Read Data from GCS  Google Cloud Storage Bucket to Azure Blob Storage. Introduction Google Cloud Storage (GCS) and Azure Blob Storage are two of the most popular cloud storage solutions available today. While both platforms offer similar functionality, there may be times when you need to transfer data from GCS to Azure Blob Storage. In this blog post, we’ll explore how to do just that using Azure Data Factory. Prerequisites Before we begin, make sure you have the following: A Google Cloud Storage bucket with data you want to transfer. An Azure Blob Storage account where you ..read more

How to Read the Data from BigQuery Table and Write to CSV File in Blob Storage Google BigQuery is a cloud-based data warehouse that allows you to store and analyze large datasets. In this tutorial, we will learn how to read data from a BigQuery table and write it to a CSV file in Azure Blob Storage. Prerequisites A Google Cloud Platform (GCP) account with BigQuery enabled. An Azure account with Blob Storage enabled. A dataset and table in BigQuery with data you want to export. Steps Open the BigQuery console. In the navigation pane, select your project and dataset. Click on the tabl ..read more

  How to Activate and Deactivate Activities in Azure Data Factory Step-by-Step Azure Data Factory (ADF) is a cloud-based data integration service that allows you to create, schedule, and manage data pipelines. In ADF, you can activate and deactivate activities in your pipelines to control their behavior during pipeline execution. This feature is useful when you want to temporarily disable an activity without deleting it from the pipeline. In this tutorial, we will learn how to activate and deactivate activities in ADF step-by-step. We will cover the following topics: Why activate and dea ..read more

 Topic: How to find out Who has created the GCP project in the Google Cloud Platform In this article you will learn How to find out Who has created the GCP project in Google Cloud Platform. To find out who has created a GCP project in the Google Cloud Platform, you can access all activity in the activity tab, on the home page of your project. You can also use Stackdriver logs and create a sink of the logs that you want to oversee into BigQuery. I hope this helps! Let me know if you have any other questions. Video Demo: How to find out Who has created the GCP project in Go ..read more

 Topic: Unroll Multiple Arrays from JSON File in a Single Flatten Step in Azure Data Factory. Here is a tutorial on how to unroll multiple arrays from JSON file in a single flatten step in Azure Data Factory . I hope this helps! Let me know if you have any other questions. Video Demo: Unroll Multiple Arrays from JSON File in a Single Flatten Step in Azure Data Factory ..read more

Topic: SQL Queries and Google BARD AI -Testing Bard for SQL Queries, ADF and Python Artificial Intelligence. Google Bard is an experimental Google chatbot that is powered by the LaMDA large language model. It’s a generative AI that accepts prompts and performs text-based tasks like providing answers and summaries and creating various forms of content.   I hope this helps! Let me know if you have any other questions. Video Demo: SQL Queries and Google BARD AI -Testing Bard for SQL Queries, ADF and Python Artificial Intelligence ..read more