Big query Can not see preview tab

[akrin28]

I imported data from AWS-S3 and I can not see the preview tab on the navigation, or see my data at all?!

[ms4446]

There are a few reasons why you might not be able to see the preview tab in Google Cloud BigQuery, or see your data at all, after importing it from AWS S3:

1. Table Creation Time: When you import data into BigQuery, it may take some time for the table to be created and the data to be processed. During this time, the preview tab might not be available.

2. External Tables: If you imported the data into BigQuery as an external table, the performance of the preview tab might be slower than native tables. This is because external tables point to data stored in another location, such as AWS S3.

3. Preview Limitation: BigQuery limits the preview to 10,000 rows. If your table has more rows, you'll only see a subset in the preview.

4. Data Issues: If there's a problem with the data, such as invalid characters or missing values, it might affect the preview. Ensure that the data is clean and correctly formatted.

To troubleshoot the issue, consider the following steps:

• Job Status: Check the status of the table import job. If the job is still in progress, wait until it's finished to see the data in the preview tab.

• Table Schema: Ensure that the table schema is correct and that the data types for each column are supported by BigQuery.

• Data Check: Examine the data for errors, such as invalid characters or missing values.

• Querying: If you can't see the data in the preview, try querying the table directly. Use the LIMIT clause to retrieve a subset of rows or the WHERE clause to filter results.

• Contact Support: If you're still facing issues, consider reaching out to Google Cloud support.

Additional Tips for Importing Data from AWS S3 to BigQuery:

• Data Transfer Tools: While the BigQuery data transfer service is optimized for importing data from SaaS applications, for AWS S3 to BigQuery transfers, consider using tools like the bq command-line tool or other third-party solutions.

• Partitioning: Before importing, partition the data. This improves query performance, especially for large datasets.

• Compression: Compress the data before importing to reduce storage space requirements in BigQuery.

[akrin28]

Thank you!! when I look into the job status I see that it was load but when
I click the table link I received this return. " Not found: Dataset
fair-yew-400815:regionrejection"

[ms4446]

If the job status indicates that the data was loaded successfully, but you're encountering a "Not found" error when accessing the table link, it's possible that the dataset or table doesn't exist, isn't accessible, or was deleted.

To verify the schema of the table regionrejecti within its respective dataset, you can use the bq show command:

bq show fair-yew-400815:datasetName.regionrejecti

Replace datasetName with the actual name of the dataset.

To list all tables within the dataset fair-yew-400815, use the bq ls command:

bq ls fair-yew-400815:datasetName

If the table regionrejecti isn't listed in the output, it might have been deleted or isn't accessible.

If you continue to face issues, consider reaching out to Google Cloud support for further assistance.

[akrin28]

Thank you. I understand what you are saying!!!!
I loaded the table from Amazon S3 and the table loaded, but I do not see
it in the job information. So I query the table and receive this return . An
internal error occurred and the request could not be completed. This is
usually caused by a transient issue. Retrying the job with back-off as
described in the BigQuery SLA should solve the problem:
https://cloud.google.com/bigquery/sla. If the error continues to occur
please contact support at https://cloud.google.com/support. Error:
48968773. When
working on the public datasets I can see the preview data. The interesting
part ins when I click explore data with sheets the data appears.

-*why in the preview table appearing *
*-why am I receiving this internal error return.*

[annebaby99]

Hello I also have the same issue however I have imported data from sheets to bq....the table was created but I can't see preview