Vertica.Database

Updated on

Vertica.Database is a Power Query M function that imports data from Vertica, returning a table of schemas available on a server. It allows additional properties to be specified, like connection and command timeouts.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

Vertica.Database(
   server as text,
   database as text,
   optional options as nullable record,
) as table

Description

Returns a table of schemas available on the server named by the server parameter in the database named by the database parameter. An optional record parameter, options, may be provided to specify additional properties. The record can contain the following fields:

  • ConnectionTimeout: A duration which controls how long to wait before abandoning an attempt to make a connection to the server. The default value is driver-dependent.
  • CommandTimeout : A duration which controls how long the server-side query is allowed to run before it is canceled. The default value is driver dependent.

Examples

List the tables in Vertica

Contribute » | Contributors: Rick de Groot