Extensions
Usage
To scan a local Delta table, run:  
```sql
SELECT *
FROM delta_scan('file:///some/path/on/local/machine');
```  
#### Reading from an S3 Bucket {#docs:extensions:delta::reading-from-an-s3-bucket}  
To scan a Delta table in an [S3 bucket](#docs:extensions:httpfs:s3api), run:  
```sql
SELECT *
FROM delta_scan('s3://some/delta/table');
```  
For authenticating to S3 buckets, DuckDB [Secrets](#docs:configuration:secrets_manager) are supported:  
```sql
CREATE SECRET (
TYPE S3,
PROVIDER CREDENTIAL_CHAIN
);
SELECT *
FROM delta_scan('s3://some/delta/table/with/auth');
```  
To scan public buckets on S3, you may need to pass the correct region by creating a secret containing the region of your public S3 bucket:  
```sql
CREATE SECRET (
TYPE S3,
REGION 'my-region'
);
SELECT *
FROM delta_scan('s3://some/public/table/in/my-region');
```  
#### Reading from Azure Blob Storage {#docs:extensions:delta::reading-from-azure-blob-storage}  
To scan a Delta table in an [Azure Blob Storage bucket](#docs:extensions:azure::azure-blob-storage), run:  
```sql
SELECT *
FROM delta_scan('az://my-container/my-table');
```  
For authenticating to Azure Blob Storage, DuckDB [Secrets](#docs:configuration:secrets_manager) are supported:  
```sql
CREATE SECRET (
TYPE AZURE,
PROVIDER CREDENTIAL_CHAIN
);
SELECT *
FROM delta_scan('az://my-container/my-table-with-auth');
```