2e:null 2f:["$","title",null,{"children":"Hello, HEAVY.AI | Observable | Observable"}] 34:T6dc,class HeavyAIDatabaseClient { static async open({ protocol = "https", port = protocol === "https" ? "443" : undefined, host, dbName, user, password } = {}) { const connector = new HeavyAI.DbCon(); if (protocol !== undefined) connector.protocol(protocol); if (host !== undefined) connector.host(host); if (port !== undefined) connector.port(port); if (dbName !== undefined) connector.dbName(dbName); if (user !== undefined) connector.user(user); if (password !== undefined) connector.password(password); return new HeavyAIDatabaseClient(await connector.connectAsync()); } constructor(connector) { Object.defineProperty(this, "connector", {value: connector}); } async describe(name) { if (name !== undefined) { const fields = await this.connector.getFieldsAsync(name); const table = htl.html`${fields.columns.map(c => htl.html``)}

name	type	precision	is_array	is_dict
${c.name}	${c.type}	${c.precision}	${c.is_array}	${c.is_dict}

`; table.value = fields.columns; return table; } const tables = await this.connector.getTablesAsync(); const table = htl.html`${tables.map(t => htl.html``)}

name	label
${t.name}	${t.label}

`; table.value = tables; return table; } async sql(strings, ...args) { if (strings.length > 1) throw new Error("query parameters not supported"); return this.connector.queryAsync(strings[0]); } }35:[] 32:{"id":"ab2de3c3f91137d1","slug":"heavyai","title":"Hello, HEAVY.AI","thumbnail":"4bf6fab3ad8588d25965bf594f9cfb73122531131cf4157772ae67582f0e1bad","access_level":"public","create_time":"$D2022-04-19T18:20:59.027Z","update_time":"$D2025-08-28T01:28:01.973Z","view_time":null,"first_public_time":"$D2022-04-19T18:52:22.893Z","has_unpublished_edits":null,"fork":false,"stars":5,"starred":false,"owner":{"type":"team","id":"f35c755083683fe5","login":"observablehq","name":"Observable","avatar_url":"https://avatars-next.observableusercontent.com/424c6c1f7794371c9915a160519bdfb34cf34e50069fcd6def38a1a04d4e9702","tier":"enterprise_2024"},"version":154,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"074c414ad1d825f5","login":"mbostock","name":"Mike Bostock","avatar_url":"https://avatars-next.observableusercontent.com/7dbba99ced40bd5ab8013c99b1a11da61231bce321ba1148a9d16ad0f121550a","tier":null}],"members":[{"type":"group","id":"c4990be612f2da51","login":"8788045797a2fd14","name":"Product Education","avatar_url":null,"tier":"public","role":"editor"},{"type":"individual","id":"074c414ad1d825f5","login":"mbostock","name":"Mike Bostock","avatar_url":"https://avatars-next.observableusercontent.com/7dbba99ced40bd5ab8013c99b1a11da61231bce321ba1148a9d16ad0f121550a","tier":null,"role":"editor"},{"type":"team","id":"f35c755083683fe5","login":"observablehq","name":"Observable","avatar_url":"https://avatars-next.observableusercontent.com/424c6c1f7794371c9915a160519bdfb34cf34e50069fcd6def38a1a04d4e9702","tier":"enterprise_2024","role":"viewer"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":4,"collection":{"id":"cb22f1322bea123e","slug":"database-clients","title":"Database Clients","owner":{"id":"f35c755083683fe5","login":"observablehq","name":"Observable"}},"type":"notebook","body":{"title":"Hello, HEAVY.AI","cells":[{"id":0,"value":"# Hello, HEAVY.AI\n\nFormerly known as OmniSci and MapD. To use in your notebook:\n\n~~~js\nimport {HeavyAIDatabaseClient} from \"@observablehq/heavyai\"\n~~~\n\nThen call `HeavyAIDatabaseClient.open`, and use the result with a [SQL cell](/@observablehq/sql).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":46,"value":"demo = HeavyAIDatabaseClient.open({\n protocol: \"https\",\n host: \"demo-flights.heavy.ai\",\n port: \"443\",\n dbName: \"newflights\",\n user: \"demouser\",\n password: \"HyperInteractive\"\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":23,"value":"demo.describe()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":36,"value":"SELECT carrier_name, AVG(airtime) AS avg_airtime\nFROM flights\nWHERE airtime IS NOT NULL\nGROUP BY carrier_name\nORDER BY avg_airtime DESC","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"flights","database":"var:demo"},{"id":99,"value":"SELECT COUNT(*) AS \"count\"\nFROM flights\nWHERE airtime IS NOT NULL","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"","database":"var:demo"},{"id":81,"value":"Plot.plot({\n marginLeft: 150,\n y: {\n label: null\n },\n marks: [\n Plot.barX(flights, {x: \"avg_airtime\", y: \"carrier_name\", sort: {y: \"x\"}}),\n Plot.ruleX([0])\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":84,"value":"---\n\n## Implementation","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":38,"value":"$34","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":141,"value":"MapDDatabaseClient = HeavyAIDatabaseClient // for backwards compatibility","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3,"value":"HeavyAI = (await import(\"https://cdn.jsdelivr.net/npm/@heavyai/connector@7/+esm\")).default","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W35","stdlib":"1","titling":"auto"}} 33:"$32:body"