You need to sign in to do that
Don't have an account?
Elizabeth Gilbert 17
Trailhead project: Query Github data, Invalid table Name Error
Hi,
I am trying to complete the "Query GitHub Data Using Big Query" project and on the thrid step am encountering the error "Invalid Table" regarding the script that I am cutting and pasting directly from the exercies. I bolded it below. Does anyone know how old the exercise is, and if the table name has been changed? Thank you.
#standardSQL
SELECT subject, COUNT(*) AS num_duplicates
FROM `bigquery-public-data.github_repos.commits`
GROUP BY subject
ORDER BY num_duplicates
DESC LIMIT 100
I am trying to complete the "Query GitHub Data Using Big Query" project and on the thrid step am encountering the error "Invalid Table" regarding the script that I am cutting and pasting directly from the exercies. I bolded it below. Does anyone know how old the exercise is, and if the table name has been changed? Thank you.
#standardSQL
SELECT subject, COUNT(*) AS num_duplicates
FROM `bigquery-public-data.github_repos.commits`
GROUP BY subject
ORDER BY num_duplicates
DESC LIMIT 100
Try below code as i guess quotes to be single quotes
Please mark it as solved if my reply was helpful. It will make it available for other as the proper solution.
Best Regards
Sandhya
#standardSQL
SELECT subject, COUNT(*) AS num_duplicates
FROM 'bigquery-public-data.github_repos.commits'
GROUP BY subject
ORDER BY num_duplicates
DESC LIMIT 100
Getting error:
Error: Encountered " "FROM" "FROM "" at line 3, column 1. Was expecting: <EOF>
SELECT subject, COUNT(*) AS num_duplicates
FROM [bigquery-public-data:github_repos.commits]
GROUP BY subject
ORDER BY num_duplicates DESC
LIMIT 100
Working code !!