python (65.1k questions)
javascript (44.2k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (12.9k questions)
How to deal with repeating player names SQL
I am working with a dataset from Basketball-Reference.com. I have collected statistics from a single season. However, players get traded throughout the season so I have players who have 2 or 3 rows in...
Claire Gehlhausen
Votes: 0
Answers: 1
Document search from BigQuery based specific text?
Here is my use case:
Employee profiles/resumes are stored in BigQuery.
The names of the employee needs to be returned when searched with a particular skill or skills.
chinmay
Votes: 0
Answers: 1
Bigquery snapshots when base table gets overwritten
Context
I have an ETL process that keeps overwritng all rows of a table in bq by deleting all first then inserting new ones. I'm looking for a data back up design that can be triggered regularly on th...
machazthegamer
Votes: 0
Answers: 1
Skip the day the email was opened and count 7 days after open in big query SQL
I am trying to block off a window within my script that will attribute a sale to a 7-day window. The issue that I am having is that I want the seven-day window to not include the open date so open dat...
user9269112
Votes: 0
Answers: 1