URI
The Uniform Resource Identifier (URI) for the Parquet resource location.
Data Type
string
Default Value
""
Remarks
Set the URI property to specify a path to a file or stream.
NOTE: this connection property requires that you set ConnectionType, which provide the
See for more advanced features available for parsing and merging multiple files.
Below are examples of the URI formats for the available data sources:
| Service provider | URI formats | |
| Local | Single File Path One table
localPath/file.parquet file://localPath/file.parquet Directory Path (one table per file) localPath file://localPath | |
| HTTP or HTTPS | http://remoteStream
https://remoteStream | |
| Amazon S3 | Single File Path One table
s3://remotePath/file.parquet Directory Path (one table per file) s3://remotePath | |
| Azure Blob Storage | Single File Path One table
azureblob://mycontainer/myblob//file.parquet Directory Path (one table per file) azureblob://mycontainer/myblob/ | |
| OneDrive | Single File Path One table
onedrive://remotePath/file.parquet Directory Path (one table per file) onedrive://remotePath | |
| Google Cloud Storage | Single File Path One table
gs://bucket/remotePath/file.parquet Directory Path (one table per file) gs://bucket/remotePath | |
| Google Drive | Single File Path One table
gdrive://remotePath/file.parquet Directory Path (one table per file) gdrive://remotePath | |
| Box | Single File Path One table
box://remotePath/file.parquet Directory Path (one table per file) box://remotePath | |
| FTP or FTPS | Single File Path One table
ftp://server:port/remotePath/file.parquet Directory Path (one table per file) ftp://server:port/remotePath | |
| SFTP | Single File Path One table
sftp://server:port/remotePath/file.parquet Directory Path (one table per file) sftp://server:port/remotePath | |
| Sharepoint | Single File Path One table
sp://https://server/remotePath/file.parquet Directory Path (one table per file) sp://https://server/remotePath |
Example Connection Strings and Queries
Below are example connection strings to Parquet files or streams.
| Service provider | URI formats | Connection example |
| Local | Single File Path One table
localPath file://localPath/file.parquet Directory Path (one table per file) localPath file://localPath | URI=C:\folder1/file.parquet |
| Amazon S3 | Single File Path One table
s3://bucket1/folder1/file.parquet Directory Path (one table per file) s3://bucket1/folder1 | URI=s3://bucket1/folder1/file.parquet; AWSAccessKey=token1; AWSSecretKey=secret1; AWSRegion=OHIO; |
| Azure Blob Storage | Single File Path One table
azureblob://mycontainer/myblob//file.parquet Directory Path (one table per file) azureblob://mycontainer/myblob/ | URI=azureblob://mycontainer/myblob/; AzureStorageAccount=myAccount; AzureAccessKey=myKey;
URI=azureblob://mycontainer/myblob/; AzureStorageAccount=myAccount; InitiateOAuth=GETANDREFRESH; AuthScheme=OAuth; |
| OneDrive | Single File Path One table
onedrive://remotePath/file.parquet Directory Path (one table per file) onedrive://remotePath | URI=onedrive://folder1/file.parquet;InitiateOAuth=GETANDREFRESH; AuthScheme=OAuth;
URI=onedrive://SharedWithMe/folder1/file.parquet;InitiateOAuth=GETANDREFRESH; AuthScheme=OAuth; |
| Google Cloud Storage | Single File Path One table
gs://bucket/remotePath/file.parquet Directory Path (one table per file) gs://bucket/remotePath | URI=gs://bucket/folder1/file.parquet; InitiateOAuth=GETANDREFRESH; AuthScheme=OAuth; ProjectId=test; |
| Google Drive | Single File Path One table
gdrive://remotePath/file.parquet Directory Path (one table per file) gdrive://remotePath | URI=gdrive://folder1/file.parquet;InitiateOAuth=GETANDREFRESH; |
| Box | Single File Path One table
box://remotePath/file.parquet Directory Path (one table per file) box://remotePath | URI=box://folder1/file.parquet; InitiateOAuth=GETANDREFRESH; OAuthClientId=oauthclientid1; OAuthClientSecret=oauthcliensecret1; CallbackUrl=http://localhost:12345; |
| FTP or FTPS | Single File Path One table
ftp://server:port/remotePath/file.parquet Directory Path (one table per file) ftp://server:port/remotePath | URI=ftps://localhost:990/folder1/file.parquet; User=user1; Password=password1; |
| SFTP | sftp://server:port/remotePath | URI=sftp://127.0.0.1:22/remotePath/file.parquet; User=user1; Password=password1; |
| Sharepoint | sp://https://server/remotePath | URI=sp://https://domain.sharepoint.com/Documents/file.parquet; User=user1; Password=password1; |