Dremio Cloud

Summary

Property Value
Connector Dremio Cloud icon Dremio Cloud
Products Power BI Dataflows (Gen1)
Power BI (semantic models)
Power Query Online
Category Database
Authentication kinds AAD; Personal Access Token
Data source kind DremioCloud
Function Reference Documentation DremioCloud.Databases
DremioCloud.DatabasesByServer
DremioCloud.DatabasesByServerV330
DremioCloud.DatabasesByServerV360
DremioCloud.DatabasesByServerV370
Support link Support

Supported capabilities

Entry point: DremioCloud.DatabasesByServerV370

  • DirectQuery

Connection parameter reference

Parameter Display name Required Type Description Allowed values Sample values
server Server Yes text Server is sql.dremio.cloud for Dremio Cloud US, sql.eu.dremio.cloud for Dremio Cloud Europe or <coordinator>:31010 for Dremio Software "sql.dremio.cloud"
projectId Project No nullable text The UUID of the project. You can find this on the Project Settings > General Information page. (Dremio Cloud only) "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx"
engine Engine No nullable text The name of engine on which to run the query. If you do not specify an engine, Dremio will auto-select an engine based on the project’s Engine Routing rules. "engine"
routingTag Tag No nullable text An arbitrary tag that you can refer to in Queue Routing rules. (Dremio Software only) "tag"
routingQueue Queue No nullable text The name of the queue to which this query should be assigned. If you do not specify a queue, Dremio will auto-select a queue based on the Queue Routing rules. (Dremio Software only) "queue"
encryption Trusted certificates location No nullable text Alternative location of trusted certificates if not using the default system trust store "Enabled-PEM"
options No nullable record