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


   server as text,
   database as text,
   optional options as nullable record,
) as table


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.


List the tables in Vertica

Contribute » | Contributors: Rick de Groot