Hi everyone. I am exploring GrowthBook with a Free cloud account to see if it would be a match for our needs. I was able to setup a flag, an experiment and a Managed Warehouse. Also some tracking with the React SDK. The flag works as expected, and I get the

Logging event to GrowthBook

logs when expected, but nothing turns out in my Managed Warehouse. First, I was getting

managed_warehouse_pending

messages, which probably means that the warehouse was not fully provisioned yet. After waiting a while, I just get

*Error updating data:*  Could not decrypt data source credentials. View the data source settings for more info.

when trying to view my experiment results. The SQL explorer is giving me

connect ECONNREFUSED 127.0.0.1:8123

errors on all queries. I cannot really control my data source credentials on a non-selfhosted instance + managed warehouse combination, so I'm wondering - how should I fix this?

Hi Jiri, good morning. I'm not too familiar with that error but the React SDK should track the experiment data to the Managed warehouse when you install the plugin here Do you have this plugin installed? Also, on the React SDK connection, which payload security option did you choose? If you're not seeing data tracked to the Managed Warehouse when using the React SDK with the plugin Please can you try to send a test event using the Ingestion API and confirm if you're able to see the event using the SQL Explorer?

Hi @flaky-noon-11399! Thanks for your response.

Do you have this plugin installed?

which payload security option did you choose?

This is my GrowthBook connection setup:

export const growthbook = new GrowthBook({
    apiHost: '<https://cdn.growthbook.io>',
    clientKey: 'sdk-xxxxxxxxxxx',
    enableDevMode: false,
    plugins: [autoAttributesPlugin(), growthbookTrackingPlugin({ debug: process.env.NODE_ENV !== 'production' })],
});

Please can you try to send a test event using the Ingestion API and confirm if you're able to see the event using the SQL Explorer?

When I run

SELECT * FROM events

in the SQL explorer, I get

connect ECONNREFUSED 127.0.0.1:8123

and no output.

are you seeing anything when you open Metrics and Data → Data Sources → [Managed Warehouse] and see if there’s any additional message in the callout about credentials or provisioning?

Attaching a screenshot of the ManagedWarehouse UI, I do not see any other messages or callouts besides the one in the screenshot

Thank you for the information. What instructions are shown when you click "`view instructions for fixing`" in your screenshot?

@flaky-noon-11399 That link takes me to https://docs.growthbook.io/self-host/env#production-settings, but those docs only refer to a self-hosted instance. I could not find anything relevant for a Cloud instance + Managed warehouse combination. Or did I miss anything there?

Thank you, I'll have to check in with the Engineering team on this. we should have an update for you later once the team come online for their day 🙌

Thanks @flaky-noon-11399!

My pleasure to assist 🌻

That's a weird random port 8123. Is that from GB Cloud?

We have identified the bug and are implementing a fix. There isn't a data loss, the bug just prevented reading from Managed Warehouses instance created within the past few days. Reading should be restored within 1-2 hours

Thank you!

My pleasure to assist 🌻