Firebolt Core + Superset: async query execution not supported, charts load sequentially

TL;DR

Use a connection string like: ` firebolt://{database}?url={url} Point url` at your Firebolt Core container's address and port. Second, to actually connect Superset to Firebolt Core you need firebolt-sqlalchemy 1.1.0+, which added Core support.

Steps

1. While evaluating Firebolt Core for Superset dashboards, the reporter noticed the docs say async query execution (set async=true) isnt supported in Core. Dashboard charts rendered one after another instead of in parallel. They asked whether async was on the roadmap and whether there was a workaround, since they only run SELECTs.
2. What actually fixes it (verified in the thread):
3. The Firebolt team clarified two things. First, the sequential charts were a driver/setup issue, not a Core limitation: Firebolt Core accepts multiple queries concurrently and executes them in parallel, so you dont need the cloud async feature for dashboard parallelism.
4. Second, to actually connect Superset to Firebolt Core you need firebolt-sqlalchemy 1.1.0+, which added Core support. Use a connection string like:

firebolt://{database}?url={url}

5. Point url at your Firebolt Core container's address and port. The reporter got it fully working on Superset 4.1.3 (a stable pre-built Superset; their custom build had the connection problem) and confirmed queries ran.

When to use

You are seeing this: First, the sequential charts were a driver/setup issue, not a Core limitation: Firebolt Core accepts multiple queries concurrently and executes them in parallel, so you dont need the cloud async feature for dashboard parallelism. Use this skill when you run into "Firebolt Core + Superset: async query execution not supported, charts load sequentially".

When not to use

If your error message or symptom does not match what is described above, this is probably not your fix. Search for your exact error text instead of forcing this one to fit.

Versions

Versions mentioned in the source: firebolt-sqlalchemy 1.1.0, Superset 4.1.3. If you are on something much newer or older, the details may have shifted.

Why this happens

The original report does not dig into a root cause. It documents the symptom and the fix that resolved it.

Someone asked: While evaluating Firebolt Core for Superset dashboards, the reporter noticed the docs say async query execution (set async=true) isnt supported in Core. Dashboard charts rendered one after another instead of in parallel. They asked whether async was on the roadmap and whether there was a workaround, since they only run SELECTs. The verified answer: The Firebolt team clarified two things. First, the sequential charts were a driver/setup issue, not a Core limitation: Firebolt Core accepts multiple queries concurrently and executes them in parallel, so you dont need the cloud async feature for dashboard parallelism.

Second, to actually connect Superset to Firebolt Core you need firebolt-sqlalchemy 1.1.0+, which added Core support. Use a connection string like:

firebolt://{database}?url={url}

Point url at your Firebolt Core container's address and port. The reporter got it fully working on Superset 4.1.3 (a stable pre-built Superset; their custom build had the connection problem) and confirmed queries ran. Full thread: https://vectle.com/threads/thrK2mCDObUgiOYsAmXuDUkQ