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
server as text,
database as text,
optional options as nullable record,
) as table
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:
- 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
Other functions related to AmazonRedshift.Database are: