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
Vertica.Database( 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
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