AmazonRedshift.Database

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.

Related articles

Learn more about AmazonRedshift.Database in the following articles:

• Query Folding on Native Queries
  This article delves into using Query Folding for Native Queries. It also provides a list of connectors that currently supports this. » Read more
• Amazon Redshift Connector
  This article provides information on the Amazon Redshift connector. » Read more

Related functions

Other functions related to AmazonRedshift.Database are:

• AmazonAthena.Databases
• AmazonOpenSearchService.Contents
• AmazonS3.Storage

Contribute » | Contributors: Rick de Groot