Hi, I'm trying to setup some testing for A/B testing, and using the Managed ClickHouse, but its taking quite a while for the database to be provisioned. How longs does it usually take to provision it? Its been over an hour so far

Hi @fresh-painter-17853 👋 You should see the Managed Warehouse render under Metrics and Data> Data sources almost immediately. Once events are tracked you should also see events in the SQL explorer immediately too

Hi, I see the managed ware house, immediately, under Data Sources, but it looks like there are no incoming events. And if I try to create a new Fact table, I get this error code, managed_warehouse_pending, so I assumed the instance was not running, but it still does not work today.. I have setup the SDK in my app, and I can use feature flags via GrowthBook, but it does not look like I get any events in my managed warehouse

Thank you for the assisted information; the

managed_warehouse_pending

message means your Managed Warehouse has been created but hasn’t been fully provisioned yet because no events have successfully reached GrowthBook’s ingestion service for your org. Provisioning is triggered automatically the first time events are received (via the SDK with tracking enabled or the Ingestion API), after which SQL Explorer and fact tables will start working. To verify events: 1. Make sure the SDK is configured with tracking enabled (e.g.

growthbookTrackingPlugin

or

data-tracking="growthbook"

) or alternatively send a test event using the Ingestion API 2. Please use the SQL Explorer to confirm the event has been successfully tracked Please let us know if you're unable to see the test event in the SQL explorer after undertaking the above? For the Contentful issue, the

Unrecognized assignment query ID: user_id

error means Contentful is trying to use an experiment assignment query called

user_id

, but your selected GrowthBook data source doesn’t have a matching assignment query configured. To fix this, go to Metrics and Data → Data Sources → [your Managed Warehouse], add a Key Attribute for your identifier (e.g.

user_id

) with type Identifier, and ensure there is an Experiment Assignment Query that returns

user_id

,

timestamp

,

experiment_id

, and

variation_id

for that data source. Then, in the Contentful app configuration, select this Managed Warehouse data source so the plugin can find and use that assignment query. The device_id is the default identifier for the Managed Warehouse so it's best that you first set up with this identifier to confirm your implementation, then join the user_id to the device_id afterwards.