Solved: YouTube Content Owner Data Transfer Failed to Get ... - Page 2

goyounjung

I've been utilizing YouTube Content Owner Data Transfer for YouTube Monetary reports.

However, since March 25, 2025, retrieving the tables below has consistently failed:

- music_content_owner_country_music_red_adjustment_revenue_summary_a1, and

- music_content_owner_country_music_red_revenue_summary_a1

{
"insertId": "13gi06jd10m5",
"jsonPayload": {
"message": "BigQuery job 867426985659:youtube_content_owner_6815a0b0-0000-2775-aa69-14c14eef63e0 (table p_music_content_owner_country_music_red_adjustment_revenue_summary_a1_kakao$20250401) failed with error INVALID_ARGUMENT: Error while reading data, error message: CSV table encountered too many errors, giving up. Rows: 12285; errors: 100. Please look into the errors[] collection for more details. File: gs://bqdts-youtube_content_owner-asia-northeast3-kqy-cxk9om0/youtube_content_owner/65f72843-0000-2cdb-99cb-30fd38133f80/68140ed7-0000-2909-b6b0-30fd3816d6ac/YouTube_loenent_M_20250401_20250430_adjustment_red_label_music_summary_lagoon_v1-1.csv; JobID: 867426985659:youtube_content_owner_6815a0b0-0000-2775-aa69-14c14eef63e0. Check BigQuery job details for more information."
},
"resource": {
"type": "bigquery_dts_config",
"labels": {
"location": "asia-northeast3",
"config_id": "65f72843-0000-2cdb-99cb-30fd38133f80",
"project_id": "prod-music-dist-project"
}
},
"timestamp": "2025-05-06T07:01:32.341104257Z",
"severity": "ERROR",
"labels": {
"run_id": "68140ed7-0000-2909-b6b0-30fd3816d6ac"
},
"logName": "projects/prod-music-dist-project/logs/bigquerydatatransfer.googleapis.com%2Ftransfer_config",
"receiveTimestamp": "2025-05-06T07:01:33.013177839Z"
}

I am not able to look into the csv file due to the permission issue.

Below is the errorstream:

Error encountered during job execution:
Error while reading data, error message: CSV table encountered too many errors, giving up. Rows: 12285; errors: 100. Please look into the errors[] collection for more details. File: gs://bqdts-youtube_content_owner-asia-northeast3-kqy-cxk9om0/youtube_content_owner/65f72843-0000-2cdb-99cb-30fd38133f80/681aa2b8-0000-2b58-9661-c82add6de828/YouTube_loenent_M_20250401_20250430_adjustment_red_label_music_summary_lagoon_v1-1.csv
Failure details:
- Error while reading data, error message: CSV processing encountered
too many errors, giving up. Rows: 12285; errors: 100; max bad: 0;
error percent: 0
- gs://bqdts-youtube_content_owner-asia-northeast3-kqy-cxk9om0/youtub
e_content_owner/65f72843-0000-2cdb-99cb-30fd38133f80/681aa2b8-0000-
2b58-9661-
c82add6de828/YouTube_loenent_M_20250401_20250430_adjustment_red_lab
el_music_summary_lagoon_v1-1.csv: Error while reading data, error
message: Unable to parse; line_number: 12187
byte_offset_to_start_of_line: 2314154 column_index: 14 column_name:
"monetized_views_t..." column_type: INT64 value: "37049628.318626"
File: gs://bqdts-youtube_content_owner-asia-northeast3-kqy-cxk9om0/
youtube_content_owner/65f72843-0000-2cdb-99cb-
30fd38133f80/681aa2b8-0000-2b58-9661-
c82add6de828/YouTube_loenent_M_20250401_20250430_adjustment_red_lab
el_music_summary_lagoon_v1-1.csv

Does anybody experiencing a similar issue?

MarvinLlamas

Hi @goyounjung,

Welcome to the Google Cloud Community!

It looks like you are encountering an issue with the YouTube Content Owner Data Transfer, specifically affecting the "music red" revenue tables since March 25, 2025. The failure stems from a change in the data format within the CSV files from YouTube. A column (probably "monetized views") now contains decimal values, while your BigQuery tables are configured to expect integers, resulting in a loading error.

Here are the potential ways that might help with your use case:

Confirm the Schema of Existing Tables: In your BigQuery console, locate your previously working table from before March 25, 2025. You may inspect its schema and identify the column name mentioned in your error log (monetized_views_t...), which appears at column_index: 14 in the problematic CSV file.. If its data type is INTEGER or INT64, this confirms your diagnosis.
Check the Data Transfer Configuration: To check your YouTube Content Owner transfer in Google Cloud Console, you can navigate to BigQuery to Data Transfers and select your transfer. While YouTube controls the schema, you generally don’t have a direct override option. Re-saving your configuration might refresh metadata.
Contact YouTube Partner Support / Your YouTube Partner Manager: You may reach out to YouTube Partner Support or your YouTube Partner Manager regarding the format change of the monetized_views_t... column around March 25, 2025, which now uses floating-point numbers instead of integers. Share your error message and ask if they can revert the format or confirm the change while guiding your BigQuery Data Transfer Service (DTS) adaptations. Check if any action is needed on your end, though DTS usually handles schema updates.
Check YouTube Partner Program Announcements: Changes are often communicated through partner emails, dashboards, or forums, so it's worth double-checking if you missed any communications. Make sure you check your inbox and notifications.

Was this helpful? If so, please accept this answer as “Solution”. If you need additional assistance, reply here within 2 business days and I’ll be happy to help.

View solution in original post

YouTube Content Owner Data Transfer Failed to Get Certain Tables