1. Log in to Snowflake:

Use the Snowflake web interface or connect through a client tool using your credentials.

2. Select the Data to Export:

Determine which tables or data you want to export from Snowflake.

3. Export the Data to a File:

• Use the `COPY INTO <location>` command to export the data to a file format supported by both Snowflake and BigQuery, such as CSV or Parquet.
• Choose a staging area that Snowflake has access to, such as an Amazon S3 bucket, Azure Blob Storage, or Google Cloud Storage (GCS).

Example command to export data to a CSV file in a GCS bucket:

```sql

COPY INTO 'gcs://<your-bucket-name>/path/to/export/data.csv'

FROM <your_table>

FILE_FORMAT = (TYPE = 'CSV' FIELD_DELIMITER = ',' SKIP_HEADER = 1);

```

1. Set Up Google Cloud Storage:

If you haven't already, create a GCS bucket where you will temporarily store the exported data.

2. Configure Permissions:

Ensure that you have the necessary permissions to read and write to the GCS bucket.

Transfer Files from Snowflake Staging Area to GCS:

   - If you exported the data directly to GCS, you could skip this step.

   - If the data is in a different location, use `gsutil` or the Google Cloud Console to transfer the files to your GCS bucket.

Example using `gsutil`:

```bash

gsutil cp s3://<your-s3-bucket>/path/to/export/*.csv gs://<your-gcs-bucket>/path/to/import/

```

1. Access BigQuery:

Open the BigQuery console or use the `bq` command-line tool to interact with BigQuery.

2. Create a Dataset:

If you don't have an existing dataset, create one where you will import the data.

3. Load Data into BigQuery:

Use the BigQuery Data Transfer Service or the `bq load` command to import the data from the GCS bucket into your BigQuery dataset.

Example using the `bq load` command:

```bash

bq load --source_format=CSV <your_dataset>.<your_table> gs://<your-gcs-bucket>/path/to/import/data.csv

```

4. Verify the Import:

Confirm that the data has been imported correctly into BigQuery by querying the tables.

1. Remove Temporary Files:

Delete the exported data files from the GCS bucket if they are no longer needed to avoid additional storage costs.

2. Review Security Settings:

Ensure that any temporary access permissions granted for the transfer are revoked.