Extensions
Usage
Once the [authentication](#::authentication) is set up, you can query Azure storage as follows:  
#### Azure Blob Storage {#docs:extensions:azure::azure-blob-storage}  
Allowed URI schemes: `az` or `azure`  
```sql
SELECT count(*)
FROM 'az://⟨my_container⟩/⟨path⟩/⟨my_file⟩.⟨parquet_or_csv⟩';
```  
Globs are also supported:  
```sql
SELECT *
FROM 'az://⟨my_container⟩/⟨path⟩/*.csv';
```  
```sql
SELECT *
FROM 'az://⟨my_container⟩/⟨path⟩/**';
```  
Or with a fully qualified path syntax:  
```sql
SELECT count(*)
FROM 'az://⟨my_storage_account⟩.blob.core.windows.net/⟨my_container⟩/⟨path⟩/⟨my_file⟩.⟨parquet_or_csv⟩';
```  
```sql
SELECT *
FROM 'az://⟨my_storage_account⟩.blob.core.windows.net/⟨my_container⟩/⟨path⟩/*.csv';
```  
#### Azure Data Lake Storage (ADLS) {#docs:extensions:azure::azure-data-lake-storage-adls}  
Allowed URI schemes: `abfss`  
```sql
SELECT count(*)
FROM 'abfss://⟨my_filesystem⟩/⟨path⟩/⟨my_file⟩.⟨parquet_or_csv⟩';
```  
Globs are also supported:  
```sql
SELECT *
FROM 'abfss://⟨my_filesystem⟩/⟨path⟩/*.csv';
```  
```sql
SELECT *
FROM 'abfss://⟨my_filesystem⟩/⟨path⟩/**';
```  
Or with a fully qualified path syntax:  
```sql
SELECT count(*)
FROM 'abfss://⟨my_storage_account⟩.dfs.core.windows.net/⟨my_filesystem⟩/⟨path⟩/⟨my_file⟩.⟨parquet_or_csv⟩';
```  
```sql
SELECT *
FROM 'abfss://⟨my_storage_account⟩.dfs.core.windows.net/⟨my_filesystem⟩/⟨path⟩/*.csv';
```