This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi guys! I am new to BigQuery, so sorry if I this is a little confusing. I have two data sources that I am trying to create some sort of relationship, but not sure how to do so. I have all of our sales in table that is connected to a Google Sheets. I have a .csv that has all of our mail data, which has 10+ more metrics than our sale data, and I have uploaded the Mail data through Cloud Storage. Both of these data sources are in their own tables. Each row of data in Sales has a matching response code in the mail data, because the customer provides us their code when they contact us and that code is in our Sale data. I am wanting to create a new table that returns only the rows of data from our Mail that a matching/ duplicate code in our Sales. How could I do this through BigQuery?
Also, if I wanted to append our Mail data each week as we send new mail out. How could I do this without making new tables each time but just adding to the data already in there?
LinkedIn
Twitter
