Remove Extra column which is automatically created in table

[NewinBigquery]

With
Chat_Kernel as (

SELECT
conferenceId, chat_creation_date_Asia_Kolkata, chat_start_date_Asia_Kolkata, chat_start_url, referrer, chat_duration_in_seconds, queue_duration_in_seconds, visitor_livechat_id, visitor_nick, visitor_ip, visitor_email, last_operator_id, group_name, rate, last_rate_comment, goal_action_name
FROM `YourDB`
LIMIT 1000
),
NewQ1 as (
SELECT
conferenceId, chat_creation_date_Asia_Kolkata, chat_start_date_Asia_Kolkata, chat_start_url, referrer,
ROW_NUMBER() over(partition by conferenceId, chat_creation_date_Asia_Kolkata, chat_start_date_Asia_Kolkata, chat_start_url, referrer)

FROM Chat_Kernel

ORDER BY conferenceId, chat_creation_date_Asia_Kolkata, chat_start_date_Asia_Kolkata, chat_start_url, referrer

)

SELECT NewQ1.*,
from NewQ1

I have written the code and i want to remove Extra column which is automatically created in table and the column name is f0_,

[ms4446]

The extra column f0_ in your BigQuery result set is likely being generated because of the ROW_NUMBER() function in your NewQ1 subquery. This function needs an alias to avoid generating an unnamed column, which BigQuery automatically names as f0_.

To fix this, you should give an alias to the ROW_NUMBER() function in your NewQ1 subquery. Here's your modified query:

WITH Chat_Kernel AS (
  SELECT conferenceId, chat_creation_date_Asia_Kolkata, chat_start_date_Asia_Kolkata, chat_start_url, referrer, chat_duration_in_seconds, queue_duration_in_seconds, visitor_livechat_id, visitor_nick, visitor_ip, visitor_email, last_operator_id, group_name, rate, last_rate_comment, goal_action_name
  FROM `YourDB`
  LIMIT 1000
),
NewQ1 AS (
  SELECT conferenceId, chat_creation_date_Asia_Kolkata, chat_start_date_Asia_Kolkata, chat_start_url, referrer, ROW_NUMBER() OVER (PARTITION BY conferenceId, chat_creation_date_Asia_Kolkata, chat_start_date_Asia_Kolkata, chat_start_url, referrer ORDER BY conferenceId, chat_creation_date_Asia_Kolkata, chat_start_date_Asia_Kolkata, chat_start_url, referrer) AS row_num
  FROM Chat_Kernel
)
SELECT *
FROM NewQ1;

In this revised query, I've added AS row_num to give an alias to the ROW_NUMBER() function. This should prevent the creation of the extra f0_ column. You can replace row_num with any name that suits your data schema.