Connect Looker Cloud to Firebolt using the PostgreSQL dialect.
Without this step, the connection will not be possible.To enable Looker Cloud connectivity, you must request this to Firebolt Support. This can be done through the UI, as described in Help Menu. When contacting Support most of the information will already be filled in, but you must provide:
Key | Value |
---|---|
Name | firebolt_connection (or any suitable name) |
Dialect | PostgreSQL 9.5+ |
Host | pg.<region_name>.app.firebolt.io |
Port | 5432 |
Database | <account_name>@<database_name>@<engine_name> |
Username | Firebolt service account ID |
Password | Firebolt service account secret |
@
:
Limit type | Threshold | Scope |
---|---|---|
New connections | 600 per minute | Per IP address |
Queries | 600 per minute | Per organization/account |
diff_days()
, diff_hours()
, contains()
, exp()
.extract_minutes()
, trunc_months()
(only work with TIMESTAMP/TIMESTAMPTZ, not DATE).date_...
or duration_...
types. Use custom SQL dimensions in .view.lkml
instead like: