Introduction
Quickstart
Azure Quickstart
AWS Quickstart
Standalone Quickstart
Cluster Deployments
Deployment Architecture
Dremio Services
Metadata Storage
Distributed Storage
Coordinator Notes System-level Caching
ZooKeeper
High Availability
Wire Encryption
Authentication
Multiple AWS Clusters
Limits
Customizing Configuration
Configuring via dremio.conf
Configuring Dremio Services
Configuring Metadata Storage
Configuring Distributed Storage
Configuring ZooKeeper
Configuring High Availability
Configuring Cloud Cache
Configuring Wire Encryption
Configuring Single Sign-On
Configuring via dremio-env
Configuring Memory
Configuring Logs and PID Location
Setting Up LDAP
Deployment Models
AWS Edition
Deploying Dremio on AWS
Deploying Dremio on AWS
Upgrade to Dremio Enterprise
Configuring AWS Edition
Configuring IAM Roles
Configuring Security Groups
Configuring LDAP
Configuring SSO in AWS Edition
Customizing Executors
Administering Projects
Create and Open a Project
Open an Existing Project
Close an Open Project
Delete a Project
Managing Engines
Creating Custom Dremio Projects
Azure ARM
Deploying Dremio on Azure
Administering Dremio on Azure
Enabling TLS for Dremio UI on Azure
Amazon EKS
Deploying Dremio on EKS
Customizing EKS Deployment
Administering Dremio on EKS
Azure AKS
Deploying Dremio on AKS
Customizing AKS Deployment
Administering Dremio on AKS
Hadoop Using YARN
MapR using YARN
Standalone Cluster
System Requirements
Installing and Upgrading
RPM Install and Upgrade
Tarball Install and Upgrade
Configuring Standalone Clusters
Deprecated Deployment Models
AWS Cloudformation
Admin Tasks
Logs
Start, Stop, and Status
Admin CLI
Backup
Restore
Reset Password
Clean Metadata
Repair ACLs
Export Profiles
Upgrade KV Store
Cleaning Up Job Results
Cleaning Up Spill Directories
Monitoring Nodes
Monitoring System Telemetry
Monitoring Cluster Usage
Managing Metadata
Querying Metadata
Caching Metadata
Managing Job Workloads
Workload Management
Queue Control
Gandiva-based Execution
Hash Aggregate Spilling
Support Settings
Data Sources
Uploading Files
Querying Files and Directories
Querying External Data Sources
Runtime Filtering
Promoting Entities
Amazon Redshift
Amazon S3
Amazon Elasticsearch Service
Amazon Glue
Azure Data Lake Storage Gen1
Azure Storage
Elasticsearch
HBase
HDFS
Hive
Ranger-Based Authorization
Connecting to a Ranger Host using SSL
S3 on Amazon EMR Configuration
IBM DB2
MapR-FS
Microsoft SQL Server
MongoDB
MySQL
NAS
Oracle
Postgres
Teradata
Data Formats
Parquet Best Practices
Delta Lake Data Format
Datasets
Concepts
Virtual Datasets
Data Curation
Jobs
Job Overview
Job Details
Job Acceleration
Job Profile
Job Metrics
Downloading Profiles
Uploading Profile Data
Querying Profile Datasets
Analyzing Profiles
Example: Number of Rows
Example: Amount of Consumed Memory
Example: Operator Type Mapping
Example: profile_attempt_0
Data Reflections
Reflections Overview
Creating Data Reflections
Refreshing Data Reflections
Offloading Operational Databases
Optimizing Data Reflections
Data Security
Sharing and Permissions
Users, Groups, and Roles
Row-Level Permissions
Column-Level Permissions
Personal Access Tokens
Inbound Impersonation
Client Connectivity
Drivers
Arrow Flight
ODBC
Windows ODBC
Linux ODBC
Mac ODBC
JDBC
Clients
Alteryx Designer
DBeaver
DbVisualizer
Looker
Microsoft Excel
Microsoft Excel PowerPivot
Microsoft Excel
Microsoft Power BI Desktop
Microsoft Power BI Gateway
Microstrategy Desktop
Qlik Sense Desktop
Python
R
SAP Business Objects
Tableau Desktop (Windows)
Tableau Desktop (Mac)
Tableau Server
Tableau SDK Connector
SQL Reference
Data Types
IBM DB2
Elasticsearch
Hive
MongoDB
MySQL
Oracle
PostgreSQL
Redshift
Microsoft SQL Server
Teradata
SQL Functions
Mathematical
Data/Time
Date/Time Formatting
String
Nested Data
Type Conversion
Conditional
Window
Aggregate
SQL Commands
Reflections
Tables
Datasets
Sources
Reserved Words
Rest API Reference
Overview
Account API
View a User
View a Group
User API
View a User
List Tokens of a User
Create a Token for a User
Delete Tokens of a User
Delete a Specific Token of a User
Token API
Delete Tokens
Delete a Token
Catalog API
Home
Space
Source
Source Types
Source Type Configuration
Source Metadata Policy
Folder
Dataset
File
Access Control
Wikis and Tags
List Catalogs
View a Catalog
View the Graph Information of a Catalog
View a Catalog using its Path
View a Catalog Wikis and Tags
Create a Catalog
Promote a File/Folder to a Physical Dataset
Refresh a Catalog
Create and Update Tags and Wiki for a Catalog
Edit a Catalog
Delete a Catalog
Reflection API
Reflection
List Reflections
View a Reflection
View Reflections Summary
Create a Reflection
Edit a Reflection
Delete a Reflection
Job API
View a Job
Cancel a Running Job
Workload Management API
View Queue Information
Create a Queue
Update Attributes of a Queue
Delete a Specific Queue
List Rules
Create and Manage Rules
Source API
Source
Source Types
List Sources
Create a Source
Edit a Source
Delete a Source
SQL API
Submit an SQL Query
Vote API
List Votes
Server Status API
KVStore Report API
Invalidate LDAP User Cache API
Knowledge Base
G1 Garbage Collection Setup
Kerberos Setup and Troubleshooting
Kubernetes Troubleshooting
Log Monitoring for AKS
Adding HBase via REST
Release Notes
15.0.0 (Dremio March 2021) Release Notes
14.0.0 (Dremio February 2021) Release Notes
13.0.0 (Dremio January 2021) Release Notes
12.0.0 (Dremio December 2020) Release Notes
11.0.0 (Dremio November 2020) Release Notes
4.9 Release Notes
4.8 Release Notes
4.7 Release Notes
4.6 Release Notes
4.5 Release Notes
4.3 Release Notes
4.2 Release Notes
4.1 Release Notes
4.0 Release Notes
3.3 Release Notes
3.2 Release Notes
3.1 Release Notes
3.0 Release Notes
2.1 Release Notes
2.0 Release Notes
1.4 Release Notes
1.3 Release Notes
1.2 Release Notes
1.1 Release Notes
Dependencies & Licenses
Dremio JDBC Driver Release Notes
11.0.0 (Dremio November 2020) Release Notes
14.0.0 (Dremio February 2021) Release Notes
Contributing to Dremio
Dremio Community
>
>
Prerequisites
Creating a connection from Looker to Dremio
Looker
Prerequisites
Dremio Looker integration requires:
Looker 5.10+
Creating a connection from Looker to Dremio
Go to Admin > Database Connections > New Connection
Select
Dremio
as the dialect.
Enter your cluster details and your credentials. Test the connection.
You can now connect to your data in Dremio!
Previous:
Next: