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.
Accept
Reject
Preferences
Log in to ask a question
Announcements
Coming Soon! We’re launching a new sub-community within the Google Cloud Community dedicated to cloud security: The Google Cloud Security Community. In preparation for the launch, this site will be in read only mode from 22 September 12am PST - 23 September 7pm PST
Log in to ask a question

Bigquery and Looker tables not synched

Posted on 08-03-2022 06:02 PM
lmendizabal
Explorer
Reply posted on --/--/---- --:-- AM

Recent modifications were made to our google bigquery tables but I don't see the modifications in my looker tables. I have refreshed my Git branch and have committed to master. In Looker sql runner I do see the modifications, what’s needed to do in Looker? The Connections test has no errors!

0 3 146
0 Likes
Reply
3 REPLIES 3

Posted on --/--/---- --:-- AM
Dawid
Participant V
Reply posted on --/--/---- --:-- AM

CTRL+SHIFT+ENTER, or selec Clear Cache and Refresh

0 Likes
Reply

Posted on --/--/---- --:-- AM
lmendizabal
Explorer
Reply posted on --/--/---- --:-- AM

Perhaps I did not provide enough explanation. We actually added additional fields in our BigQuery tables that I don’t see in our Looker tables, so clearing cache did not do it. Also, initially I added  webhook deploy secret to the project configuration but have since removed it. Could this be why the tables are not synching? Thanks

0 Likes
Reply

Posted on --/--/---- --:-- AM
Dawid
Participant V
Reply posted on --/--/---- --:-- AM

There seem to be few steps missing. Have you added your fields to LookML? Have you deployed your LookML changes to production? Where did you check your “Looker tables” - in sql runner or an explore

0 Likes
Reply
Top Labels in this Space