The database configuration process should follow the same logic as when Configuring a BigQuery Database. Customers can easily reference their warehouse credentials in the Connection tab of their Warehouse settings page:
Ensure that the Looker user has:
- SELECT privileges to all schemas to be explored (Segment implementations generally have a schema per tracked domain, plus any additional schemas added by the customer).
- Ownership of the Looker scratch schema. Note that the scratch schema is REQUIRED when using the Segment Block with Looker, because the model requires the creation of multiple PDTs for event processing.
Additionally, because we need to accommodate for scaling event data that may become much larger–a few additional things should be confirmed with Segment (if Segment hosts):
- 30 minute time-out window has been removed from queries. By default, Segment terminates queries at 30 minutes, this needs to be removed for PDT creation to complete in many cases.
👉 Continue to Table Structure
👈 Back to Block Overview
🏠 README Table of Contents