AmazonRedshift.Database

Updated on

AmazonRedshift.Database is a Power Query M function that imports data from an Amazon Redshift database, returning a table listing the tables on the Amazon Redshift cluster with controls like Provider Name and Batch Size.

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

Syntax

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

Description

Returns a table listing the tables on the Amazon Redshift cluster server in the database database. An optional record parameter, options, may be specified to control the following options:

  • Provider Name: A text value to use as the Provider Name for the connection. This is used when using Microsoft Authentication.
  • Batch Size: The number of rows that are fetched in a single call to the server.

Learn more about AmazonRedshift.Database in the following articles:

Other functions related to AmazonRedshift.Database are:

Contribute » | Contributors: Rick de Groot